Compare data that do not exactly match

[ModernGIS]

I am in the process of comparing data from (2) different databases to find
differences in the same type of data. Example: I have customer names in one
system and a customer name in a different system and I need to make a
comparison to see if it is the same name. Lets say I have Account # 34234 in
both databases/tables and in one of them the account name is Smith, John R
and in the other is Smith, John. Since both do not fully match, it could come
back in the unmatch query. How would I do this so the query could tell that
is close to be the same, compared to account name (1) Smith, John is not the
same in account name (2) being Riley, Bob. This I unmatch I want to come back
for further investigation.
Thanks

 

[Jeff Boyce]

Access isn't smarted that you. If you don't have a way you can explain to
Access for resolving which values are "close enough" and which aren't,
Access won't do this.

If you were going to explain how to decide to ... say ... your grandmother,
how would you explain that?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Jeff Boyce]

And apparently, I aren't either ...

My response should have started out "Access isn't smarter than you."

I plead diminished capacity and ask to be properly caffeinated...

Regards

Jeff Boyce

 

[Wilpeter]

Since both tables contain Account# (and presumably are table-linked), try
making Query containing both tables and Names & Account# from each. That
limits list to matched Account#s. Fields must be Shown in output. Then make
2nd Query containing first Query and the (reliable) Table. Include Account#
and Names from each source, with criteria for Name field [Reliable].[Name] <>
[QueryName].[Name]
That should at least give you the questionable list to validate.