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