Looking for a solution to this that I can use in the query design window.



Basically, I have A list of text strings in one table, and a list of surnames in the next. I want to basically replicate a "contains" function in excel except I want to apply it to every string by every surname.

I tried Like [Surnames]![Field1] but as you can imagine that didnt work out too well.

So if any cell/string from table "UKClean" contains a word from the table "surnames", Place in query 1.

Thank you for your help in advance