trying to compare two tables

[Drew]

Hello,
Not sure if this is the way to go…
I’m trying to compare tbl 1 to tbl 2. From the compare, I would like to produce a list of records from tbl 1 that aren’t contained in tbl 2. Similar to a fuzzy search??
Ex.
Record 1 in tbl 1 “A0” exists (contained) in all 14 records from tbl 2, so this would be excluded from the results list.
Record 2 in tbl 2 “A0%%%0” exists (contained) in the first 2 records from tbl 2, so this would be excluded from the results list. Etc…
Record 8 in tbl 2 “A0%%%1D”, doesn’t exist in tbl 2, so this would be part of the list. Etc..

Table 1 Table 2
A0 A0%%%0A
A0%%%0 A0%%%0B
A0%%%0A A0%%%1A
A0%%%0B A0%%%1B
A0%%%1 A0%%%2A
A0%%%1A A0%%%2B
A0%%%1B A0%%%3A
A0%%%1D A0%%%3B1A
A0%%%2 A0%%%3B1B
A0%%%2A A0%%%3B1C1
A0%%%2B A0%%%3B1C2
A0%%%2C A0%%%3B1D
A0%%%3 A0%%%3B1E
A0%%%3A A0%%%3B1F
A0%%%3B

So, results from the example above would be:
Tbl
A0%%%1D
A0%%%2C

Thanks for the help.
Drew

 

[mdmilner]

If and only If you're looking for exact matches you can take a shot at the 'Find Duplicates' QBE Wizard interface built into Access. Viewing the SQL code that it generates would be a great demo on how to futher modify it to do what you might need.

If you're familiar with defining fields inside a query, you could always use that to extract portions of strings to compare in the same fashion.

I would recommend that if both topics are new to you, that you try them out separately and then try to combine them once you get them down.

Mike