Comparing 2 simple tables

[JayR]

I haven't used Access in over a year and I need to pull some information from a database. I currently have 2 tables consisting of 2 columns each. What I am trying to compare are accession numbers on each list and need to know which accession numbers do not appear on the second list.

Table 1 is AccesionGyne07, with records ID and 1 (being the accession number in format of GY-07-#####).
Table 2 is AccessionGyne07MCCSP, with records ID and 1 (same as above).
Table 1 has about 30,000 values in it and Table 2 has about 26,000 values. Hence I am 'missing' 4,000 accession numbers that I would like to locate and have in a separate table.

So what I was trying was setting up a query between the 2 tables, linking the "1" record (although I cannot remember how imperative it is) and then trying to set criteria to say if it isn't in table 2, show it. I couldn't get that to work. I could get it to show which ones were in table 2....but that isn't helpful.

I realize this is something pretty simple, but I don't use Access/ODBC/SQL enough anymore and quite frankly cannot remember most of the basics either. Any and all responses are greatly appreciated.

Thanks in advance,
Jay

 

[boblarson]

Look at using the Unmatched Query Wizard when you select NEW QUERY.

 

[JayR]

Thank you Thank you Thank you

Thank you very much. I knew it was simple and I knew I had done it a few times before.
You are a life saver!
Thanks again,
Jay

 

[boblarson]