Filtering in a Query Using a Keyword

M

MO

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.
 
K

Ken Snell [MVP]

This would be what the criterion expression will resemble:

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

MO

Thank you so much....it worked!

Ken Snell said:
This would be what the criterion expression will resemble:

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

--

Ken Snell
<MS ACCESS MVP>

MO said:
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.
Click to expand...
Click to expand...
 
Top