creating a query that asks for a parameter that is a part of a field - TechRepublic
Question
July 10, 2008 at 07:25 AM
nepon

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

by nepon . Updated 17 years, 12 months ago

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 discussion is locked

All Comments