How to Search for keywords in a Query

[Brian62]

I have a query that I want to be able to change my search criteria by keyword(s). I want it to be able to ask me to enter keyword to search for so I can filter it to a report.

Here is what I have tried with no success:

Search for Keyword: Enter Keyword [" "]
Search for Keyword: Enter Keyword *" "*

 

[rainman89]

You will want something like

Like "*" & [Enter keyword] & "*"

Of course this assumes that you type the keyword in correctly....

 

[Brian62]

Thanks! Worked perfectly!