Find Records from 2 Tables

depawl

Registered User.
Local time
Today, 02:45
Joined
May 19, 2007
Messages
144
How would one go about comparing 2 tables and finding those records that are not common to both tables? For instance, I have a table that I suspect some records have been accidently deleted by the user. I would like to compare that table to an older version of the table, and list only those records that exist only in the older version of the table.
Thanks.
 
Look into using the Unmatched Query wizard.
 
Thanks Bob,
I knew that Access had that capability but couldn't remember where to find it.
 

Users who are viewing this thread

Back
Top Bottom