query problem

[eran3185]

i have a report.
one of the parameters on that report is "amount"
i want a query that ask the user "enter amount" and then the user get only the records that low then the amount that the user fill-in.

[OBP]

eran, the query is where you put the parameter.
In the Amount Column's Criteria Row type in
[Enter Amount]


Make sure that your Report uses that Query for it's Data Source.

[eran3185]

hey
but if the user fill in "500" - he get all the records with 500 , but i want all the records that low (400 , 420 , 450 etc...)

[OBP]

eran, place a
<
in front of the
[Enter Amount]

so that you have
< [Enter Amount]

[eran3185]

thanks