Creating a query that contains Unmatched data

[Artemis Hothmire]

Good afternoon,

I am trying to create a query that matches two other querys and finds records that are in the primary, but not the secondary query. I have tried to use the query wizard for this, but it will not work for me the way I want.

If I have A,B,C,D in one query and only have A,B,D in the other I want to find C, so that I can format an email funtion in my database using that data. Thank you in advance for your assistance.

-Arty

 

[plog]

You need a LEFT JOIN (http://www.w3schools.com/sql/sql_join_left.asp). If you need more assistance provide the names of your queries and their fields.