Finding Difference in two tables

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I have two tables that contain some common fields.
Table 1 has 11904 records and table 2 has 9126 records. Table two was
derived from table 1. I need to find the 2778 records in table 1 that are
not in table 2. Anybody have any ideas? Thanks.
 
Jim

Use the query wizards. Select the "Find Unmatched..." wizard.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top