Results 1 to 2 of 2
  1. #1
    Matze0710 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2015
    Posts
    5

    Query and Update Items which has been changed

    Hello guys,



    I need a query to update items which has been changed or new. I like to use an append query and an update query, but I do not know how I can start.

    Best regards

    Matthias

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    in a new query,
    bring in the table you want to change
    using the icons on the bar, change the query to UPDATE query
    dbl-click the field you wish to change
    in the row: UPDATETO put the value you want the record to be changed to.
    bring down any other fields if you need a WHERE clause.
    save

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Running Update Query On Selected Items Only
    By sdrmason in forum Access
    Replies: 4
    Last Post: 09-10-2014, 08:32 AM
  2. Replies: 4
    Last Post: 05-14-2014, 10:03 PM
  3. Default value doesn't update when date is changed
    By TheHarleygirl2005 in forum Programming
    Replies: 4
    Last Post: 08-30-2013, 05:57 PM
  4. Replies: 3
    Last Post: 03-12-2013, 01:38 PM
  5. Replies: 1
    Last Post: 03-20-2011, 05:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums