Multiple Exclude / "Unmatched" Query | Access 2010

Question

I am using Access 2010, trying to do an exclude via the UI (2nd join type and then "Is Null") but am trying to do that for 3 fields.

Specifically:

I need access to return any records from one table where a match is not found in 3 fields.

Phone, Email and Company are the fields and I need access to return any records in table 1 where Phone does not match in table 2 AND Email does not match in table 2 AND Company does not match in table 2.

Any ideas?

I have tried to do a triple type-2 join with "Is Null" in each criteria like a typical exclude but it is returning more not fewer matches (acting like an OR instead of AND by the looks of it)

Update: thank you to Hans for the solution. I have included a picture of it to help others in my situation

Answer 1

Do you want to return all records for which there is no match on the combination of the fields Phone, Email and Company? If so, create a triple outer join as you have done.

But if you want to return all records for which there is no match on Phone, and also no match on Email and no match on Company, you need to add the second table three times to the query.

Create an outer join to the first instance on Phone (with Is Null in the criteria), an outer join to the second instance on Email (also with Is Null in the criteria) and an outer join to the third instance on Company (ditto).

Answer 2

Thank you sir!