Ranking positions

[Sonrie]

Hello,

I have made a query where I select data about a contestant and his total points and results in a competition. I have ordered these on total score.

I want to rank each contestant in a competition on who has the best results.

Best contestant – position 1, 2nd best contestant – position 2 and so on.

Should I make an attribute in the table that I name “position”?

I have tried to find helpful hints in the Tek-Tips forums and on the web, but not succeeded.

Can someone please help me?

Sincerely,
Sonrie

 

[Trendsetter]

If you are only doing this in a query and the rankings will change constantly then use can use an Alias in the query.
-An Alias is just another name for something!

If you are grading each contestant according to a position in the competition then you need to record the position in the table, but if the position is derived from the score achieved in the competition then you can get the ranking by using the alias:
New column in the query!
Name......... Ranking:[CompetitionScore]
Order By..... Descending - highest first

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[Sonrie]

Hello,

Yes, the position is derived from the score achieved in the competition.

I tried that, but I want to have the number 1, 2, 3, and so on in the Ranking-field. Now I only get the same scores as in the CompetitionScore-field.

How is it possible to show the contestants position number in the Ranking-field?

Sincerely,
Sonrie