Wildcard Table

[alex]

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?

 

[KARL DEWEY]

Make the wildcard table that looks like:
Company
polo
crew
gap
d*k
then in criteria use Like "*" & [WildcardTable].[Company] &
"*"

 

[alex]

Make the wildcard table that looks like:
Company
polo
crew
gap
d*k
             then in criteria use    Like "*" & [WildcardTable].[Company] &
"*"

--
KARL DEWEY
Build a little - Test a little

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?- Hide quoted text -

- Show quoted text -

Thanks Karl for the quick response.
When I enter the code above, Access thinks it's a parameter and asks
for a "Parameter Value"

 

[KARL DEWEY]

You have to have the table in your query. In design view put it in the part
of the grid you have your other table but do not join.
--
KARL DEWEY
Build a little - Test a little

Make the wildcard table that looks like:
Company
polo
crew
gap
d*k
then in criteria use Like "*" & [WildcardTable].[Company] &
"*"

--
KARL DEWEY
Build a little - Test a little

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?- Hide quoted text -

- Show quoted text -

Thanks Karl for the quick response.
When I enter the code above, Access thinks it's a parameter and asks
for a "Parameter Value"

 

[alex]

You have to have the table in your query.   In design view put it in thepart
of the grid you have your other table but do not join.
--
KARL DEWEY
Build a little - Test a little

Make the wildcard table that looks like:
Company
polo
crew
gap
d*k
             then in criteria use    Like "*" & [WildcardTable].[Company] &
"*"
--
KARL DEWEY
Build a little - Test a little
:
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?- Hide quoted text -
- Show quoted text -

Thanks Karl for the quick response.
When I enter the code above, Access thinks it's a parameter and asks
for a "Parameter Value"- Hide quoted text -

- Show quoted text -

That worked...Thanks Karl for your help.