Filtering in a Query Using a Keyword

[Guest]

Here is what I want to do...I want to set up a parameter query that prompts
for a keyword when clicked on. I want that keyword to be like a filter that
will pull all documents that have any reference to that word. The problem I
am running into is that I do not have a keyword field. I am trying to search
through a title field that has a lot of other words in the field. I know how
to use the "like" expression but I can't set it up so that it will pull up
all records that are "like" the parameter entered.

 

[Ken Snell [MVP]]

This would be what the criterion expression will resemble:

Like "*" & [Enter the text string:] & "*"

 

[Guest]

Thank you so much....it worked!

This would be what the criterion expression will resemble:

Like "*" & [Enter the text string:] & "*"

--

Ken Snell
<MS ACCESS MVP>

Here is what I want to do...I want to set up a parameter query that prompts
for a keyword when clicked on. I want that keyword to be like a filter that
will pull all documents that have any reference to that word. The problem I
am running into is that I do not have a keyword field. I am trying to search
through a title field that has a lot of other words in the field. I know how
to use the "like" expression but I can't set it up so that it will pull up
all records that are "like" the parameter entered.