Search for a list of keywords in a string

Hi,

I have a access database that has a table containing some keywords and those keywords are mapped to some text. I have a functionality which allows users to upload PO data to the access database. this PO data has some Item text. I want to use this Item text and compare it to the keywords table and apply the rules for the keywords where the keywords match the words in the Item text. Please let me know how can we do this

Thanks
Vishal

You can use the InStr function to locate a specific string within a string. This is one option for what you want to do.

You can also do it with a Query. In the Where clause use Like with wildcards.