Good Afternoon,
I have two tables linked by Name. The names are not unique and may have Corp., or Corp. or Corp in one table and Corporate spelled out in another table. Some may have a hypen separating names etc..
I would like to create a query to see all the records and fields from the table on the left and only a few fields from the second table on the right if the names are similar and state matches.
I was able to create the query but my results are for the exact matches on the name.
Thank you for your assitance.
Laurie B.