By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,021 Members | 952 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,021 IT Pros & Developers. It's quick & easy.

Determing data changes in access query

cori25
P: 83
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
Sep 12 '08 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
Try adding a field called DateLastModified 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/ac...345351033.aspx

http://support.microsoft.com/kb/197592
Sep 14 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.