Locating companies based on key words in their Co. Name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large Company Name table of 500K+ company names and addresses. I would like to identify those that are in the home building business - those with certain key words in their name like "builder, home, house, developer, etc". The only way I've figured out to do this is to type "build* or hous* or home or devel*" in the criteria box of a query and run it with the Company Name table.

Is it possible to set us a small table with these key words (with the wildcards) and run a match query that would spit out company names that contain the key words (like Builder Bob Inc, Custom Home Builders, etc)?
Thanks for any advise
 
Yes. You might use a query whose SQL looks something like this:

SELECT DISTINCT
[Your Company Name Table].*
FROM
[Your Company Name Table],
[Your Keyword Table]
WHERE
[Your Company Name Table].[Company Name] Like "*" & [Your Keyword
Table].[Keyword] & "*"

It might take a while, but this will return a list of records from your
company name table where the company name contains at least one of the
keywords in your keyword table.

Doug said:
I have a large Company Name table of 500K+ company names and addresses. I
Click to expand...
would like to identify those that are in the home building business - those
with certain key words in their name like "builder, home, house, developer,
etc". The only way I've figured out to do this is to type "build* or hous*
or home or devel*" in the criteria box of a query and run it with the
Company Name table.
Is it possible to set us a small table with these key words (with the
Click to expand...
wildcards) and run a match query that would spit out company names that
contain the key words (like Builder Bob Inc, Custom Home Builders, etc)?
 
Back
Top