Track Changes made by Update query (1 Viewer)

[kapaw]

Is there a way to show all rows that was updated by an update query? I have a tblMCN where the data comes from a temp table. If the MCN is new it goes from temp table to tblLogs to tblMCN(using append query) then just updates the tblMCN using update query. My dilemma now is to show the users which MCN were updated and which field f the MCN was updated:
MCN fields:

MCN /Part Type / Description/Lifecycle Phase/ MPN Status/ Checked

 

[Guus2005]

add a date/time field named LastUpdated and use it to store the timestamp the record was changed.
you have to change all update/append queries to store the current timestamp into your table.
in a separate logtable you can store the timestamp and the username. this way you will be able to see who perfomed the change on a specific timestamp.

HTH