Query to find "No Match" or "Non-existence" 1

[cashewsky]

Hello. This is my first time here (I'll be back often, I believe). I have a question concerning a query and two tables.

Table One:450 records
-fields: BenCode, Amount
Table Two:200 records
-fields: BenCode, Description

I am trying to write a query that takes the first field (BenCode) in a table and tests to see if it DOES NOT EXIST in the the second table. I only want to see those BenCodes in the first table that do not have a match in the BenCodes field of the second table.

So far I have tried:
WHERE table1.[Ben Code] <> (table2.[Ben Code]);

but it returns roughly 200 * 450 records, and that makes sense to me, I just don't know the process of determining non-existence.

Any help is appreciated greatly!
~Cashewsky

 

[randy700]

Why not simply use the Find Unmatched Query Wizard?


Randy

 

[cashewsky]

sounds like a great (obvious) idea! It worked perfectly. Thank you!