I have a table with a single column of text strings (of sentences).
I can query for a single word with =Instr([textfield],"searchstring") -- that gives a positive integer if found.
Now, I have a table with 20 "searchstrings".
Can I query that table somehow to find any instance of any of those strings in the target?
Then also, can another query find every instance of all the strings.
I guess the tables have to be joined somehow (???) or perhaps a subquery can be the criteria and use OR for each.
For a little more detail, if it helps -- the responses survey comments. I have found the top 20 significant words used. Now I can find which comments those words are found in.
Thanks for your help.