Access 2010: backwards query

[Lingg]

Hello
I'm currently trying to make a query that does the opposite of what a regular query does. I have two tables that have fields of personnel ID's. The first table is the master table which has all of the possible ID's and the other table will have a few missing. I want to create a Query that shows the ID's that are missing from the second table.

please reply if what I've stated isn't understandable or if I'm missing something that might help out.
Thanks

 

[Joe4]

Try using the "Unmatched Query Wizard" that Access offers. It will walk you right through the set-up.

 

[Lingg]

That worked great, Thanks Joe.

The trick is to put Is Null as a criteria for the selection that doesn't exist in the other table.

 

[Joe4]

The trick is to put Is Null as a criteria for the selection that doesn't exist in the other table.

You got it, and make sure that you use a Left Outer Join (instead of an Inner Join).