Matching Fields

[Guest]

I have two sets of data with the same company names, but not all the company
names exactly match up....for Example I have one set that says

Company
Kroger
Building Houses
Architecture Plus

And one set that says

Company
Kroger Inc.
Building Houses LLC
The Architecture Plus Company

I need these fields to match up with each other in a query. Is there a
query or expression to write that would match up these companies even though
they have slight differences?

Thank you

 

[Guest]

Have a look at LIKE. That might help

 

[Guest]

Yes, LIKE does work if I'm querying only one table, but I'm attempting to
cross reference two tables, like ones in example, only thousands of records
long. If you can use LIKE or any other criteria or code, what would it be to
match up these companies that contain the same type information, only input
differently?