creating a query that asks for a parameter that is a part of a field

By nepon ·
I am trying to create a key word search of a field that contains about 6-10 key words in the field as well as many non key words. I can create the query, using the key word I want, using the string- Like "*trexler*" - but I would like to have the query prompt me for the parameter that in this case is 'trexler'. I would like it to ask me what I want to search for. I can use the [] brackets to make it prompt me, but I can't just put in the string above and have it work.
How do I construct it?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums