Find records in one table that don't exist in another table

[jjmclell]

Hi there,

I have two tables and I'd like to find any records in the one table that don't exist in another table.

The first table is simply a list of names where some names may repeat - no field to link it to the primary key of the other table, just a list of names. I'd like to compare it to a base list of names in the second table where no name repeats to see if there are any records in the first table where the name was spelled incorrectly etc. Is there a way to query records from the first table that don't match any names in the second table?

[orange]

Look at the query wizard -- Unmatched query

[jjmclell]

Ahh, thank you kindly. Figured there was a simple approach. I looked at the design view of the query afterwards and understand how it's done now with or without the wizard.