find duplicate entries without exact same field values

[robert]

I'm trying to compare two tables (both with a field for
company name) to see how many companies are found in both
tables. However one table may have the company name with
punctuation or an abbreviation where the second table has
the same company name, just with different abbreviations,
punctuation etc. Is there a way to compare these two
tables and compensate for the possible differences in
company names?

 

[Ken Snell]

There is a wizard in ACCESS query that allows you to do this. From the
database window, select the Query objects window. Then click "New" icon and
a wizard will allow you to select Find Duplicates query. It'll lead you
through the process.