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