Help with search (find) using a calculation

[Nakizimbo]

Okay, calculations are not my strength and I am struggling with soemthing which I believe shoudl be relatively simple. I have a searchable  field which will always contain a one or two digit number.  For example, if I want to search for all records containing a number between 0 and 4 I can do this by entering "<5" in the search box.  However, because of the nature of my database I do not want my user to have to enter "<5" into the search box but I simply want him to be able to enter "5" which then becomes calculated as <5 so as to bring up all records with 0, 1, 2, 3, or 4.  If I can do this within my "show custom dialogue Script" that would be great or can it be done as a calculation in autoenter ?  any help appreciated.

[doughemi]

Add to your script right after the Custom Dialog step and before the Perform Find step:

 

Set Field[YourTable::YourField; "<" & YourField]

[Nakizimbo]

Thank you very much. Works perfect.