Query to find Values that do NOT exist

[SoonerLater]

I have two tables (Household and Relationships). Both have a field named Household_ID.





How can I structure a query which basically says, "Find all records in the Households table whose Household_ID does NOT appear in the Household_ID field of the Relationships table?"

The query I've written:



does not work. Obviously I am doing this wrong. How should I re-write this query to produce the desired results?

[orange]

Look at the Access unmatched query wizard.

[ItsMe]

It looks about right to me. Double click the JOIN line and make sure you have selected, "Include ALL records from 'Household' and only those records from 'Relationships' where the joined fields are equal."

[SoonerLater]

Look at the Access unmatched query wizard.

Thank you, that achieved my goal.

[SoonerLater]

It looks about right to me. Double click the JOIN line and make sure you have selected, "Include ALL records from 'Household' and only those records from 'Relationships' where the joined fields are equal."

Ahhhhh!!!! Light bulb! That's wonderful. Not only did that work, I learned.