Determing data changes in access query

[cori25]

I have data in a table for the entire month which breaks out by date, each day I am running the data and updating what currently exists for that day so any changes made will be captured. For example, today, 9/12/08, I run the updates and want to determine if any of the data has changed from what was currently there. My first appraoch was to create a query where the table with the current data for 9/12/08 and the updated data for 9/12/08 would be linked and then created an if statement to tell me if any of the fields <> each other. Therefore knowing that something had changed and what exactly it was. I had no luck.

I appreciate any assistance.

-Cori

[puppydogbuddy]

Try adding a field called DateLastModifie d to your table and a related control on the applicable form which is bound to that control. Then you will to query transactions based on the date last modified. If you need details of what was modified, you need an audit trail or log table. See the following links for details on how to implement.

http://office.microsoft.com/en-us/access/HA010345351033.aspx

http://support.microsoft.com/kb/197592