Queries

[Guest]

I am trying to create a query that has a simple criteria expression (i.e. > 5
or >10). However, I want the number that the field should be less than (the 5
or the 10) to be imputed by the user. Is there any way for me to run a query
that prompts a message box and imputs the users response as the number in the
criteria. Thanks

 

[Guest]

This will do it for you --

[Enter the lowest value to search for]

 

[John Vinson]

I am trying to create a query that has a simple criteria expression (i.e. > 5
or >10). However, I want the number that the field should be less than (the 5
or the 10) to be imputed by the user. Is there any way for me to run a query
that prompts a message box and imputs the users response as the number in the
criteria. Thanks

Sure. It's called a "Parameter Query".

Use

[Enter lower limit:]

on the criteria line. The user will be prompted with whatever text you
put in the brackets; whatever they type in response will be used as
the query criterion.

John W. Vinson[MVP]