E
Emma Aumack
I have two seperate membership lists. One list is a Customer list that has
an Account number as the unique identifier. The other list has a Member ID as
the unique identifier. I need to find the best way to match these two lists.
I was thinking of matching on the first, say, 10 characters of the address,
then city and state. I would creating a query with a concatentated field for
this information for each table, and seeing how many pop up as matched. But
I really need to come up with an algorithm to get around stuff like E. vs.
East, and P.O. vs. PO. Has anyone had any luck with doing this?
an Account number as the unique identifier. The other list has a Member ID as
the unique identifier. I need to find the best way to match these two lists.
I was thinking of matching on the first, say, 10 characters of the address,
then city and state. I would creating a query with a concatentated field for
this information for each table, and seeing how many pop up as matched. But
I really need to come up with an algorithm to get around stuff like E. vs.
East, and P.O. vs. PO. Has anyone had any luck with doing this?