Match data by first few characters???

[dellyz]

I"m trying to run a query by matching on customer name but the sources that I got the names from differ/have been truncated. I'm trying to search on the first few characters of the name to get back the matched results. an example if I was trying to match "United Airlines" with another database that shows them as "United Airl", how can i tell the query to only match on the first 8 characters? thanks

 

[Joe4]

Create two new queries from each of your tables. Add all the fields, but make the ID/Name fields a calculated field:

NewName:Left([Name],8)

Now, link these two new queries based on this "NewName" field.