How do I Rank Scores

[rshort50]

I am crating a database to compute student scores for a contest. I have most of it done, but cannot find a way to easily/ automatically calculate their rank. For instances the highest score is 1, next highest 2, etc. Any help would be great.

[mr_vodka]

What is the structure of your tables? What happens where there is a tie? Do you need to store their ranking of only for display purposes. Any further details would help.

[rshort50]

The table is set up with a variety of catagories that the scores are entered into. Then there is a field for the total score, which is calculated by adding the other together. I would like ties to show the same rank, with the next value being skipped. For instance a tie for 2nd place would show both records being 2, and no 3rd listed.

The rank would be used to sort records, assign awards, and be exported.

[Genx]

Are there multiple score sets and or multiple totals?

[rshort50]

Each student has one total

[Genx]

What happens if two students have the same score?

[Genx]

See if the attached helps. I've made a few assumptions -- I used a repeating field just to keep it simple, c_totalScore just has to be the total of all your fields.

ranking.zip

[comment]

I would like ties to show the same rank, with the next value being skipped.

ranking.fp7.zip

[Genx]

Oops.. I always seem to miss something don't i.