Unmatched Query in Access 2003???

  • Thread starter Thread starter Nadia
  • Start date Start date
N

Nadia

Is there any way I can run an unmatched query in Access
2003. I can't seem to figure it out. Access 97 made it
too easy. I'm simply trying to compare a list of id
numbers in one field in one table to a similar list of
ids in one field in another table. I need to know which
ones do not exist in the second table. Please help ASAP!
 
A2003 should have the same query wiz as A97.

It's actually very easy:
1. Create a query with the 2 tables.

2. Double-click the line joining the 2 tables.
Access pops up a dialog offering 3 options.
Choose the one that gives you all records from the desired table.

3. Drag the primary key of the other table into the grid.
In the Criteria row under this field, enter:
Is Null

The outer join (step 2) yields all records from one table.
The criteria (step 3) chooses those with no match in the other table.
 
Back
Top