Duplicates by text field partition

[mick bartels]

Hi all!
I'm trying to find duplicates by matching the address
fields in 2 different tables:

SELECT [Table1].Address, [Table1].City, [Table1].State,
[Tabel1].ZIP
FROM [Table1] INNER JOIN Table ON
([Table1].Address=Table2.Address) AND
([Table1].City=Table2.City);

Even though 123 Main Street in Table1 is the same as 123
Main ST. in Table2, it doesnt query through because the
text is not exactly the same. I tryied using LIKE vs. =
but no luck...any ideas??

Anything would be very much appreciated.
Thanks!!

 

[Jeff Boyce]

Mick

How close is close enough? You're going to have to decide, and come up with
a way to tell Access how to evaluate for closeness.

On names and addresses, you can find exact matches easily, but I rely on
"USB" when it comes to "close" matches (USB -- Using Someone's Brain).