G Guest May 3, 2005 #1 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?
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 May 3, 2005 #2 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!
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!
G Guest May 3, 2005 #3 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.
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.
