how to track changes in data

E

ejamac01

I am running an append query on a table of which will change the underlying
data. Is there a way I can see the changes?
 
R

Rick B

An append query will not change records, it will add records. An update
query changes them.

As far as seeing the changes, just open the table after you run the query,
and there they are!
 
E

ejamac01

Thanks Rick

My aim is to change the data that is already in the table. For example I
have a table which records the date of death. So i need to know when that
field changes.
 
Top