Return to FileMaker.com
Need Minimum Number
I have both a found set in which there is a score field for each record. I need the minimum score of the found set. FM11 Adv both Mac and Windows
Define a summary field as the minimum of your score field.
Sort your records by the score field. Depending on whether you sort in ascending or descending order, the minimum score will be the first or last record in the found set.
Retrieving data ...