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?