troubleshooting Question

Access 2003 - find multiple strings within single string

Avatar of billb1057
billb1057Flag for United States of America asked on
Microsoft Access
6 Comments1 Solution792 ViewsLast Modified:
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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros