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 matches of 7 or more consecutive characters within the sentences
SELECT TEST.DELETION, DATABASE.*
FROM DATABASE, TEST
WHERE ((((InStr([TEST].[DELETION],[DATABASE].[A])))>1));
Any help on this would be greatly appreciated, as I have read a lot of articles and tutorials, but this seems to be a little more complex that I thought.
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 matches of 7 or more consecutive characters within the sentences
SELECT TEST.DELETION, DATABASE.*
FROM DATABASE, TEST
WHERE ((((InStr([TEST].[DELETION],[DATABASE].[A])))>1));
Any help on this would be greatly appreciated, as I have read a lot of articles and tutorials, but this seems to be a little more complex that I thought.