F
flowerpowers
Guest
Hi, I have a question about parameter queries. I would like to use a parameter query where the user can type in a search string in a parameter query. I know that to make the query ask for the criterion, you can enter a question in square brackets in the query design window. E.g. for a database of countries, you can enter this as a criterion for country name:
[Enter name of country:]
And for countries with population greater than a user-input value, you can have:
>[Enter minimum population:]
However, what if I want the user to be able to type in a search string in the prompt and then have Access look for records where that string appears in a memo or text field? I know I can do that with wildcards directly in the query design window, by entering f.ex.
Like "i*"
But that is hardcoded into the query - I would like to know how to do that in a parameter query, so that the user can decide what the search string is. In the example about countries, what if the user cannot remember the spelling of say "Philippines", and so they want to type in just "Phil*"? As mentioned, you can do that in the query design window, but how do you design a parameter query that allows you to type in just part of the value stored in a field and shows you all records where the input value appears?
That was a long-winded questions - hopefully with a short and simple answer.
Thanks for any hints!
[Enter name of country:]
And for countries with population greater than a user-input value, you can have:
>[Enter minimum population:]
However, what if I want the user to be able to type in a search string in the prompt and then have Access look for records where that string appears in a memo or text field? I know I can do that with wildcards directly in the query design window, by entering f.ex.
Like "i*"
But that is hardcoded into the query - I would like to know how to do that in a parameter query, so that the user can decide what the search string is. In the example about countries, what if the user cannot remember the spelling of say "Philippines", and so they want to type in just "Phil*"? As mentioned, you can do that in the query design window, but how do you design a parameter query that allows you to type in just part of the value stored in a field and shows you all records where the input value appears?
That was a long-winded questions - hopefully with a short and simple answer.
Thanks for any hints!
