Calculation Fields

[Greg M]

I am working on a database to manage a cross-country ski race. I need to calculate team scores in several ways. I have the Racer ID field, the team field, and the time field. I need a calculation field for each team that will calculate the team's average time. I also need a calculation field for each team that will calculate its score - the sum of the rankings of the team's four racers with the lowest times.

[Lee Smith]

Hi Greg,

Russ Baker contributed a file awhile back having to do with racing, I haven't looked at it, but it might help you in your endeavor.

Here is the link

HTH

Lee

[Lee Smith]

Also, check this file out at Ray' site, I think the file is called "Calculate sorts and competitive rankings across records 3 Files, and it 's by Ray J. Cologon. Here is his URL, while there you might look around, he has many excellent example files:

http://www.nightwing.com.au/FileMaker

Lee