General discussion
November 29, 2000 at 03:00 AM
mfoster

Fuzzy search on text value, Access Query

by mfoster . Updated 25 years, 8 months ago

I have a table that has multiple customer master records in it for the same customer. I would like to create a report that shows the records that are possible duplicates. I need to use a “Fuzzy Search” on the name to collect as many hits as possible since the same customer might be entered as A.B. Company, AB Company, A B Company, A.B. Co., etc. I need help on the “Fuzzy Search” part. Any help would be appreciated.

This discussion is locked

All Comments