Find records using script

[sam215]

I want to find those records whose total is >1000. How to write this in script.I try smthng like these.

Set Variable[$a;Value:1000]

Enter find mode[]

setfield[Table:Total;">"&$a]

PerformFind[]

But this is not working.

[Matthew F]

What sort of field is "Total"?  If it were a regular number field then the script should work. 

 

Incidentally, you can do the same without the "Enter find mode" and "Set Field" steps, by specifying the Find request on the "Perform Find" step, and setting Total to > $a (without quotes)