Calculation needed for ranking order?

[pigeon]

Hi all,

I have a database for students who have graduated from their degree. I want their final ranking to appear in a layout (letter).

Eg. Joe Blog graduated in the ceremony held on 12th May 2007. Joe was ranked 25th out of 200 students in his ceremony group.

I do a find on the field 'graduation date'and I sort based on the field 'final average mark' (which is a calculation). I view in List Mode and I can see Joe's rank for his graduating year.

How do I capture this information in a letter?

I'm assuming I would create a field 'ranking' which would contain a calcuation. The calculation would need to determine:

1.the total number of students for any given graduation date.

2. Identify a student's rank within that total number.

Any ideas?

Thanks.

Edited April 5, 2009 by Guest

[comment]

See:

http://fmforums.com/forum/showtopic.php?tid/201199/

http://fmforums.com/forum/showtopic.php?tid/184727/