Finding Difference in two tables

[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.

 

[Jeff Boyce]

Jim

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

Regards

Jeff Boyce
Microsoft Office/Access MVP