Prompting user for criteria

[srburk]

For the purpose of creating a report, the user is prompted to enter his criteria.

I would like (within my query) to create a prompt that allows the user to say, "Show me all data with less than 5 units." So, in my criteria what do I put???

I would guess:
[ENTER < AND UNIT]

so the user enters <5 and <enter>. Nothing appears.

Any suggestions? The user is not limited to enter <5. He could enter <2, >3, <10, etc... anything.

Scott

 

[Nero]

One method would be to create a custom form to enter your criteria rather than use the standard input boxes and use a combobox based on a query to select your criteria.
I probably have an example somewhere. I will try and dig it out.