Identifying records updated or exceptions

[cmac]

Hello,

I have a rather basic Update query that runs correctly. The join is on only
matching records between the tables. I would like to be able to see what
records were either updated or identify the exceptions (where a match was not
found). Can someone please help?

Thank you -

 

[Jerry Whittle]

On the table being updated add a new Date/Time field named LastUpdated.

In the update query put the following and make sure that it is set to update
the proper field in the table.:

LastUpdated: Date()

Assuming that you only do one update a day, you can now query the table with
criteria like below to see what records were updated or not updated:

= #10/3/2008#

<> #10/3/2008#

If you plan on running this update more than once a day, use the Now()
function. However this could make looking up the last update a bit more
complicate.