Search results

Hello, Sorry for being ambiguous - what I am looking for is the first seven characters in field 58,57,56,54 to be matched against the Deletion column in the Test table. Now in the Deletion column, this value could be found in a sentence , but that won't always be the case. Essentially, I...

Hello Majp, I am always looking for the first 7 characters to be matched, I do not care about any substrings.

Hello, What I am trying to compare is the Deletion Column (Test Table) to columns 58,57,56,54 (Extract Table) and find matches. In columns 58,57,56,54 all of those fields will have values of 11 characters. These 11 characters can be alphanumerical ( in the sample document provided they...

Hello All, Sorry for the delay in getting back to you. What I need help with is - I am comparing two tables in Access and need to compare the Test table to the Extract table. In the Test table I am comparing the Deletion column to the Extract table and am looking for matches in either Column...

Hello All, I am currently writing an access query to compare two tables and find matches. The only problem I have encountered is, I needs to find matches within sentences. I used the below, but unfortunately it is finding matches that contains the any of the characters and I want to find...