Mact query from a list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table of 1800 names on a master table that I am trying to match to a
table of 70,000 vendor names. I want to see a match if the name on the
master table is John Smith but the name on the cendor table is John C Smith.
Is there any way to do that in Access?
 
hi,

Yes. You would do an INNER JOIN query, or a LEFT JOIN query. Create a new
query in design view. In the design view, choose both tablesa, and join them
by name or nameID. Then you can run the query.

Hope this helps,
geebee
 
If all of your data is like John Smith vs John C Smith
then create query for each table as below.

First_and_Last_Name: Like Left([YourField], InStr([YourField], " ") -1) &
"*" & Right([YourField],Len([YourField])-InStrRev([YourField]," "))

Then join these in a third query.
 
I have a table of 1800 names on a master table that I am trying to match to a
table of 70,000 vendor names. I want to see a match if the name on the
master table is John Smith but the name on the cendor table is John C Smith.
Is there any way to do that in Access?
Click to expand...

Not reliably.

Is John Smith the same as J. C. Smith?
Is John Smith Data Services Inc. the same as JCSmith Dataservices?

This kind of matching almost surely requires a human intelligence.

John W. Vinson[MVP]
 
Back
Top