Triple Exclude / "Unmatched" Query | Access 2010

[DavidMichaelangelo]

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 AND Email AND Company do 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)

[June7]

Post the SQL statement for analysis. Is it using OR operator?

[DavidMichaelangelo]

I don't work with SQL statements directly, I use the UI which I have included an image of the setup below.
I have pasted in the SQL below as well, but I am hoping to find a solution within the UI

SELECT [02 Remove Tests].PromoCode, [02 Remove Tests].FirstName, [02 Remove Tests].LastName, [02 Remove Tests].BusinessPhone, [02 Remove Tests].BusinessEmailAddress, [02 Remove Tests].BusinessNameFROM [02 Remove Tests] LEFT JOIN [Campaign Members] ON ([02 Remove Tests].BusinessEmailAddress = [Campaign Members].Email) AND ([02 Remove Tests].BusinessName = [Campaign Members].Company) AND ([02 Remove Tests].BusinessPhone = [Campaign Members].Phone)
WHERE ((([Campaign Members].Phone) Is Null) AND (([Campaign Members].Company) Is Null) AND (([Campaign Members].Email) Is Null));

[June7]

Well looks good to me.

If you want to provide data, attach file. Follow instructions at bottom of my post.

[DavidMichaelangelo]

Thanks for offering to help June.
I found the solution here:

http://answers.microsoft.com/en-us/o...a-36e3621d9c95

Here's a pic for other people's reference: