how to track changes in data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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!
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2010 append query to SQL is very slow 0
query field names changing to expr#: 8
Append Query Issue 0
Data changes in append query 1
Numeric Field Overflow when appending date - how to convert it to text 1
Update query that is updating fields not included in any statement 4
Appending null data and moving! 4
Appending zero-length string 3

Back
Top