Rank in Access

[Guest]

I have made a very basic programme in Access which has marks of different
students in different subjects. I want to rank these students as per their
total
marks in a querry or table and not in a report. As of now everytime I have
to resort them and then manually type the
Rank. Is there a better way wherein the software ranks the students depending
on the number of students?
I do not want to use excel as there I have to specify the cell Range in the
rank formula. If the number of students vary I have to rewrite the formula
again
To be precise I am looking for the exact functionality of Rank function in
Excel. The formula should keep extending the Range of selected cells as I
keep adding the Data.
Sorry to bother u but I am an absolute novice. So be specific if u can.
Thanx a ton in advance

 

[MGFoster]

I have made a very basic programme in Access which has marks of different
students in different subjects. I want to rank these students as per their
total
marks in a querry or table and not in a report. As of now everytime I have
to resort them and then manually type the
Rank. Is there a better way wherein the software ranks the students depending
on the number of students?
I do not want to use excel as there I have to specify the cell Range in the
rank formula. If the number of students vary I have to rewrite the formula
again
To be precise I am looking for the exact functionality of Rank function in
Excel. The formula should keep extending the Range of selected cells as I
keep adding the Data.
Sorry to bother u but I am an absolute novice. So be specific if u can.
Thanx a ton in advance

This site gives info on how to rank queries:

http://support.microsoft.com/support/kb/articles/q120/6/08.asp

 

[Guest]

Thanx a lot. I had visited the page before but while building the expression
as in example 2, I was using the syntax as [Countof Total] rather than[Total]
itself which was resulting in all the students being ranked as 1. Now the
problem is resolved.
Thanx for your time.

 

[Charles]

Dear M G Foster,

You cannot imagine how I have searched for such a helpful reply as that bit
of yours that pointed to the KB article which is now entitled:

How to Rank Records Within a Query

and is now available at:

http://support.microsoft.com/kb/q120608/

Thank you Very Much Indeed

Charles