Highlighting the best result

[bstretch]

Dear All

I am in need of some assistance in getting FileMaker to report the age champions from the school athletics carnival. I have summary fields that total all of each athletes points that they accrue and have got as far as making FileMaker 'highlight' the person who has the most points. That's in one layout.

My problem is - I want to have another layout/report that only shows the top 3 age champions in each age group (opens, u17, u16 and so on). This is probably as clear as mud, but I think it's a fairly simple and easy thing to do.

Is anyone able to give me some assistance in doing this?

I can send the FileMaker file over to anyone who is able to help, it's small.

With many thanks

Cheers

Ben.

[email protected]

[Fitch]

It depends how your file is set up. If the points totals are all part of each record, or are added from a related file, set up a script to do this:

Sort (descending) on the point totals

Go to Record 4

Omit Multiple -- use a huge number like 99999

If the points totals are Summary fields, you can use the same procedure, buy first you'll have to export the summary data, or set up a related file that totals the points.