Track changes to records updated using an update query

[Luis Freitas]

I know how to track changes when they are done using a form.

Can they also be tracked if I run an update query?

[MMcCarthy]

I know how to track changes when they are done using a form.

Can they also be tracked if I run an update query?

Only if you run the update query in code or add something to the query to update a field in the same table.

[Luis Freitas]

Only if you run the update query in code or add something to the query to update a field in the same table.

My initial idea was to create a "history" table with the fields would be RecID, FieldChanged, OldValue, NewValue.

We have a table with more then 2 million records and every week I have to download from our Head Office a table that has new records and changes to existing records.

The table has 21 fields and 19 of them can be changed by the update query.

Can you help me with the code for the update query?

Thanks