Set a field to be less than a value on a button click

[#1]

I'm having trouble figuring out how to make a field less than an entered textbox value on a button press.

I have a field called Sales and a textbox where the user can enter a number. What i'm trying to do is after the user enters a number and presses the button, the page will only show sales less than that number.

So in the action dialog under "Select in Field" and i the "Search String" box i've been trying to set a field Sales to <MAX(EnteredNumber).

This isn't working though. Any ideas? Thanks!

[hector · Accepted solution]

Hi, with this sintax in the search string worked for me

= '< $(=InputValue)'

[#3]

Thanks Hector works Great. I wasn't really sure what was acceptable in "search string". Seems like a funny name for that field but oh well, it works!

[#4]

Hetor, if you dont mind i would also be interested in knowing how to do this for 2 values. So that sales is between two entered fields.

= '< $(=InputValue1) AND > $(=InputValue2) doesn't work

Thanks.
'

[hector]

Hi

the problem is the "AND" word, try with

= '> $(=InputValue1) < $(=InputValue2)'

Remember when you are filtering in the field, you don't use the "AND" word, you just use >5<=10

Rgds