I'm trying to do a SELECT query to pull up values in one table (tblOne) that do not match any of those in a second table (tblTwo). The first table contains newly imported data with no key (with fields matching those of the database). The second table is a listing of allowable designations, each with a unique key. They are in a text format like this AA/BB, AB/BB, AC/CC, etc. The SQL i've been using is:

SELECT DISTINCT tblOne.Designation
FROM tblOne, tblTwo
WHERE ((tblOne.Designation)<>(tblTwo.Designation));

I can get a query working that matches records with common designations with no effort at all...but the same can't be said for the opposite (which is what I want). I can't get a query to spit out the records in tblOne with designations that do not match those listed in tblTwo. My goal is to use the query as a tool to list the designations that I need to add to tblTwo. Would anyone mind helping me out on this?

Hi,

From what I have read, you are looking to records that exist in one table and not the other. If this is the case, use the unmatched query in Access. Go to queries, new and unmatched queries and then follow the wizard. This will provide you with everything in one tabler, but not the other. You can then manipulate this for yourself.

Hope this helps

Martin

I can't believe I didn't try that straight-away. Thanks for the assist!