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?