Writing a Query as a Module

  • Thread starter Thread starter Hanif Merali
  • Start date Start date
H

Hanif Merali

Thanks for your help Jeff. Perhaps I can do it using an update query
but I have been unsuccessful in my attempts. Let me try and explain
what I'm tryint to do a bit better. I have a table called Commercial
Key Words which has 1 column datatype=text, another table called
Customers which has tons of columns one of which being Name, I want to
search each records name to see if any of the strings from the
Commercial Key Words table are contained in that records name, if they
are contained then I wish to update a column on the Customers Table.
Seems like it would work with an update query but I'm not sure how to
check all 1376 strings from the commercial table to each record in the
Customers table. So far the only comparisons I've odne are 1-1.
Thanks for the help!

Regards,

Hanif
 
Hanif

When you start a new thread (as this is), it loses all connection with the
earlier discussion. Consider posting this back into the original thread.
There may be others following that discussion who have relevant
questions/answers.
 
Back
Top