Hello experts,

I have a query based on a table...In the table is a column named
"company."

This column contains the names of hundreds of companies with
duplicates and different spellings of the same company (I cannot edit/
normalize this table).

In my query, I can use a wildcard to find all instances of a company.
E.g., [ like *polo* ] to obtain every record of the Ralph L Polo Inc.
company and its variations.

If I wanted to search for another company, I would place another
criterion on the line below (for an 'or' or on the same line for an
'and').

My question is:  Instead of typing all of these criteria in the
"Criteria" section of the query window; can I base the criteria on a
table.  Let's say a wildcard table that looks like:
Company
*polo*
*crew*
*gap*
*d*k*

Reason being:  This table gets populated daily (again, I have no
control) and I'd like to keep a running list to continually scrape for
the old companies and add fresh criteria for new ones.

Thoughts?