Office Software Thread, Access Update Query... in Technical; I've been asked to update the Assets we have recorded in our main database, the site staff wish to update ...
23rd June 2011, 01:54 PM #1
Access Update Query...
I've been asked to update the Assets we have recorded in our main database, the site staff wish to update with a complete new log.
However they don't want to wipe the database and start again, they want to have a character placed at the start of the existing Assit IDs...
I know what I'm looking to do, just can't remember what I've got to do to get the results I want...
24th June 2011, 11:46 AM #2
Never mind, I've remembered...!
Originally Posted by MaceZ4
Just for those who would like to know...
In the update query enter the cell you want to update and in the Update To bit enter the following:
Making sure that the cell name is the same as the one you are updating... If you're doing it the same way as me that is...
By dwhyte85 in forum MIS Systems
Last Post: 5th October 2010, 04:25 PM
By randle in forum Office Software
Last Post: 9th November 2009, 02:17 PM
By garethedmondson in forum Office Software
Last Post: 29th January 2009, 10:14 PM
By Pashers in forum Coding
Last Post: 28th October 2008, 09:32 AM
Last Post: 27th October 2008, 09:20 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)