Finding changes between two historical tables

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

Guest

Hello group,

This is probably a really easy question to answer. I hope it is!

I have one table with about 20 fields that I am backing up every week.
During that week, a few records will change. Only one or two fields in any
given record will actually change during this time period.

I want to be able to take two historical copies of the table and compare
them to see what changes have been made. Is there an easy way to do this
using standard Access queries?

thanks!
BD
 
hi,
yes there is.
Click the query tab in the database window. click new
query. click the 'Find unmatched query wizard'. follow the
instructions.
Regards
Frank
 
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

Historical Data 5
Historical tracking of records 3
Looking for changes in records after update 2
Making changes lead to unintentional historical changes 3
Searching for changes in large groups of records 2
Using the OnTimer event to lock out users between specific time window. 12
Access Updating inventory levels 0
Altering Combo Box Choices and the bearing on historical data.... 7

Back
Top