Find comparing 2 fields within a record

[DaveC]

Hi,

I've got a database of salesmen with fields headed Name, Target and Sales. I'd like to find all records where Target is greater than Sales. I can't seem to find an easy way to enter this into the Find screen; the only way round so far has been to create a calculated field with the formula if(Target>Sales,1,0) and then Find on 1 in that field. I'm new to FMP (version 6) and would appreciate any help on this.

Thanks in anticipation.

Dave

[BobWeaver]

Yep, that's the way to do it. Filemaker doesn't have any simpler method to do that kind of search.