Find Unmatched Query Problem

[Jim Bailey]

I'm running Access 2002 and have tried numerous times to
get the Find Unmatched Query Wizard to work. I'm using
Tables with fields labeled SSN in each. Each field is
Text Length 15. I always get the same record count as
the first table. There are 11 verified matches. Any
ideas??? Thanks. jim

 

[John Vinson]

I'm running Access 2002 and have tried numerous times to
get the Find Unmatched Query Wizard to work. I'm using
Tables with fields labeled SSN in each. Each field is
Text Length 15. I always get the same record count as
the first table. There are 11 verified matches. Any
ideas??? Thanks. jim

Please post the SQL of the query that isn't working.

Or... create a Query joining the two tables by SSN. Select the Join
line and choose option 2 - "Show all records in the <first table> and
matching records in the <second table>". Select ONLY the SSN field
from the second table, and apply a criterion of

IS NULL

This will now show only those records in the first table which do not
have a matching value in the second.