When you're designing your query and you specify your criteria by dragging the desired attribute into the criteria window, there should be a checkbox at the bottom of the critera screen to "prompt user to specify value". When the query is run, the value that they input is used as the criteria.
Hmmm.... I wonder if this is a feature I don't have. I am not able to drag attributes into the criteria window. I can just point and click items on the window. I have I am accessing the web version of the console. When editing a query, it has 4 steps, (1) Search conditions, (2), Attributes to display, (3) Sort results by attribute, and (4) Run query. In the search conditions, I must select a attribute from the list and then enter a value for that attribute. If I don't do that, when I click ok, it complains that I have to enter a value. But I want it to prompt the user for the value instead. I don't know if there is a special code that I can enter in the value field to force the query to prompt the user, like it's done in MS Access. Any ideas? Thanks for your help.
There are quite a few differences in query design between the Console application and Web Desk, this is one of them. There are many enhancements to Web Desk queries coming in the next major release, version 7.4, due later in the year. There may be something new to fit your need then.