Records from 1 table that do NOT have a match in a second

[Steve Happ]

How do I create a query to include all the docs from table1 that don't have
matches in table2?
For example:
Table 1
IDs: 1,2,3,4
Table 2
ID: 3
Yields IDs 1,2,4

Thanks
Steve

 

[Rick B]

Use the query wizard to build an "unmatched" query.

 

[Steve Happ]

Hello Rick:

I don't find any option for an "unmatched" query. How do I do this?

Thanks

Steve

 

[Rick B]

Go to the query tab of your database.

Click the "New" button

In the New Query Dialog Box, select "Find Unmatched Query Wizard".

 

[Steve Happ]

Thanks Rick. That does it.

Steve

Go to the query tab of your database.

Click the "New" button

In the New Query Dialog Box, select "Find Unmatched Query Wizard".