Give Sum Query a Ranking

[waq963]

Hi, I have a query where a student gives scores for certain statments and the query does a sum of those scores. Is it possible to give the student a ranking in the query based on the scores they got? Thanks

 

[Poppa Smurf]

It is possible Go to this knowledge based site http://support.microsft.com/kb/120608/en-us it describes How to Rank records Within a Query.

I have provided a sample solution on another forum at this location
http://www.dbforums.com/microsoft-access/1637933-show-ranking-report.html

Message #9 is the solution using the supplied database.

Note This query does not show the next number if there are more than one on the same ranking. If there are 27 records with a ranking of 1 the next record would show a ranking of 28 and not 2.

 

[Rabbie]

Typo in link in above post. correct link is http://support.microsoft.com/kb/120608/en-us