Find based on field value being greater or less than another field value?

[mrswombat]

Hello,

 

Is it possible to script a find that specifies "omit records if the numerical value of field A is less than the numerical value of field B"? I can get conditional formatting to highlight a field when this is the case, but can't seem to get a script to work for this find. Sorry if this is in the wrong category--it's kind of a scripting and find problem in one.

 

Thank you!

[Lee Smith]

You can benefit a lot by going through the tutorials. Performing Finds Link is the link to start with.

 

Lee

[Raybaudi]

You could create a calculation field, result number:

 

FieldA ≥ FieldB

 

and then do a find for that field = 1

[LaRetta]

Yes but you must capture the value of field B before entering find mode (since fields have no value in find mode) similar to

Set Variable [ $b ; table::FieldB ]

... Then your find script here... using $b as the search criteria "<" & $b

[mrswombat]

Thank you all very much. Problem solved!