might be easy

[cstuckey56]

Hello,

I working with different business groups who have vendors assigned to them. I have table of vendor names for each business group. I'm getting data from different sources with vendor names that are unlike table. example: ABC company, ABC. Even through these are different they are they same vendor. Is there a formula, criteria, etc. to pick these up? I will be updating the vendor table occastionally.


Thank you

 

[Jkittle]

This is database which means it looks at entry field individually and if the data does not match then is a different record. You should use a unique supplier code or make your entry field a pull down option box so your data is always consistent.

 

[neileg]

Access dosen't do fuzzy matching. You could have a table populated with all the known variations of a name matched to whatever you wan't to standardise to, but it will only work if you have covered ever possibility.

 

[cstuckey56]

Access dosen't do fuzzy matching. You could have a table populated with all the known variations of a name matched to whatever you wan't to standardise to, but it will only work if you have covered ever possibility.

Thanks Neil,
I was afraid that was the answer. I made a table with all the variations and will continue to populate.

 

[gemma-the-husky]

you might be able to use a generic soundex function, although that might "match" some companies that shouldnt match.

soundex tries to assign a "rough" value to any string so that

bardon and barden would probably be assigned the same soundex value