parameter query

[malako]

need to create a parameter query in access. The question says, "the query should prompt the user to Enter Threshold. The query should display all results that are less than or equal to the threshold but greater than or equal to 1." Can someone tell me what the expression would look like?

[June7]

Try:

SELECT * FROM tablename WHERE [some field] BETWEEN 1 AND [enter threshold];