Query Question with Partial Matching

Originally Posted by ConneXionLost

Hi patnyc,

Here's one of the best VBA tools for attempting to accomplish the type of task you're currently facing.

It's complexity serves as a fitting reminder as to why we use proper numerical keys as opposed to people's names to match records in databases.

Cheers,

Hi, Thanks for the reply. I wish it was that simple. Unfortunately, our end does but their end does not. We have unique identifiers but our vendors will send us csv or excel files with just raw data from their database.

Thanks for the link, I'll take a look.

Would I some how be able to use the Left syntax?

It's listed as Last, First (i cant compare it to JUST the last names because of common names like "brown".


Right now the results from the query come up like this:

Brown, Mike | Brown, Mike
Smith, Christoper | [empty cell]

Now, the way I confirm the MATCH is if the matching name is next to it. There is a Smith, Chris in the list I'm comparing it too but it wont match it with that code I pasted above. How would i incorporate a usage of Left and let's say the first 5 characters? This way it would match 'Smith, Christoper' and I would also be able to see a incorrect match of "Smith, Christian". As long as the matches are visible it would help me greatly.

let me know if you can help...I've been trying to understage the logic behide the main code but my Access 2007 book hasn't arrived yet.

I figured it out!

I view the results and see if there is an actual match. This works really well.

Please Login or Register  to view this content.