Find values < or > in comparison fields

[cfahle]

I'm trying to do a find which will display only numbers which are greater than or less than a comparison field. For example, I have API scores for schools from 2004 and 2005. I want to do a find which will show ONLY schools which made a gain in their API from 2004 to 2005 or, a find which shows only schools which decreased in their API scores from one year to the next. I'm sure this has to be an easy solution but I can't seem to find a way to get this to work. Any help would be appreciated.

Edited June 15, 2006 by Guest

[LaRetta]

Assuming Comparison is a global and if I understand correctly, this will work:

Set Error Capture [ On ]

If [ not Comparison ]

Show Custom Dialog [ "No value in Comparison" ]

Halt Script

End If

Enter Find Mode [ ] ... uncheck Pause

Set Field [ API ; ComparisonField ]

Perform Find [ ]

If [ not Get ( FoundCount ) ]

Show All Records

End If

Show Omitted Only

This performs a find for all records EQUAL to the Comparison number then omits them, leaving those that are less than or greater than Comparison number. If no records are found matching Comparison, then all records are shown because all records will be less than or greater than Comparison.

LaRetta