Query records where value in field is not found in field from another table

[dougdrex]

Using Access 2010



I have a relatively simple db. It only has two tables. Each table has a field that concatenates the values from three other fields (concatenation performed in Excel before importing). I want to query the records where the value of the concatenated field in one table is NOT found in the concatenated field of the other table.

The query uses both tables and creates a relationship between the two fields. I'm having a brain freeze on how to only include the rows from the table I'm working on (field called "Unique_Key") that do not have a matching value in the concatenated field from the other table (field called "Unique_ID").

Let me know if my explanation does not make sense.

Thanks!
Doug

[June7]

Have you tried the Find Unmatched query wizard?

[John_G]

In the query design view, set the properties of the join (right-click on the join line) to show all records from table A and only releated records from table B (Option 2).

The result will give you all records in table A, and rows where there is no matching record in Table B will have blanks for the Table B data.