Finding changes between two historical tables

[Bob Dobalina]

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

 

[Frank Stone]

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