+ Post New Thread
Results 1 to 2 of 2
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 ...
  1. #1
    MaceZ4's Avatar
    Join Date
    Dec 2010
    Location
    Lots of different places...
    Posts
    129
    Thank Post
    12
    Thanked 12 Times in 8 Posts
    Rep Power
    11

    Cool 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...

  2. #2
    MaceZ4's Avatar
    Join Date
    Dec 2010
    Location
    Lots of different places...
    Posts
    129
    Thank Post
    12
    Thanked 12 Times in 8 Posts
    Rep Power
    11
    Quote Originally Posted by MaceZ4 View Post
    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...
    Never mind, I've remembered...!

    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:

    Code:
    "Characters"&[Cell Name]
    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...



SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Query, SIMS and access to DB
    By dwhyte85 in forum MIS Systems
    Replies: 35
    Last Post: 5th October 2010, 04:25 PM
  2. [MS Office - 2007] MS Access query help
    By randle in forum Office Software
    Replies: 7
    Last Post: 9th November 2009, 02:17 PM
  3. Access - Date Query
    By garethedmondson in forum Office Software
    Replies: 12
    Last Post: 29th January 2009, 10:14 PM
  4. Image Update Query
    By Pashers in forum Coding
    Replies: 4
    Last Post: 28th October 2008, 09:32 AM
  5. SQL update query
    By MACIT in forum Coding
    Replies: 4
    Last Post: 27th October 2008, 09:20 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •