Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006
    Posts
    2

    Return records not updated by update query

    Forgive me if this question has been asked before but I tried a search in the forum and it didn't seem to work very well.

    I have 2 tables, each with a few thousand records. I enter values in fields in table one and it calculates some of the other fields.

    I then run an update query and update the records in table 2 based on the calculated fields from table 1.



    The update query shows me how many records were updated in table 2 but I would like to be able to generate a list of all the records that weren't changed through the update query. Is that list tracked anywhere in Access or is it something I need to write a VBA procedure to accomplish?

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    One simple way would be to run a SELECT query on Table2 before running the update query, and set up the WHERE clause so that it is the opposite of the WHERE clause in the UPDATE query.

    Of course, I should warn you against storing calculated values in a database anyway--generally, this is a bad idea, and should be avoided.

    Patrick

  3. #3
    Join Date
    Apr 2006
    Posts
    2
    Thanks Patrick, that's not a bad idea. I should be able to put that in easily.

    As for storing calculated values, I didn't have much option. The database is converted from an old Revelation A database and the client wanted it to run exactly as it did before. (Minus the DOS interface :roll: )

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

Similar Threads

  1. Replies: 0
    Last Post: 11-12-2008, 05:18 PM
  2. Return Record # In Query
    By redwinger354 in forum Access
    Replies: 1
    Last Post: 09-15-2007, 01:08 PM
  3. Need help with an Update query ...
    By valkyry in forum Queries
    Replies: 0
    Last Post: 04-23-2007, 08:45 PM
  4. Need help with Update Query
    By starswinger007 in forum Queries
    Replies: 1
    Last Post: 02-22-2006, 08:44 PM
  5. macro to updated tables
    By Wrangler in forum Import/Export Data
    Replies: 1
    Last Post: 01-18-2006, 11:01 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