I have a list of records and would like to have a script that would find the records where Field 1 is greater than Field 2. It should be simple but I can't figure out how to get the second field in the find after the > sign.

Table::Field 1 > Field 2

When I try it I get - Table::Field 1 [> Field 2] - and it says it can't find any records that match criteria.

Filemaker doesn't perform calculations during find. Either define a calculation field =

Field 1 > Field 2

and search for a value 1 (true) in it, or go over the records one-by-one.

Thanks, I was hoping it would be easier than that.

I know you can do a Field 1 > 0.00

So I thought this would be similar. Thanks now I can quit digging through the help files.