Ranking of Students based on Obtained Marks.

[Jamaluddin]

I have a table for storing Examination Records of Students. Table have many other fields but the target fields are the Total Obtained Marks (ObtMarks) and the Rank. I need to find the Rank of Students based on their Obtained Marks in Exam. The Query is sorted in descending order so that the highest result comes at top. If we use the simple Serial Number method for finding the Rank, its ONLY OK when all students got unique marks. But the situation is that some, i.e., 2 or more students may got same marks. The attached picture is a sample report which I need to get from the Exam Table.



How to get this report / query using MS Access. I am using Access 2003.

Thanks.

[Jamaluddin]

I found the following sample query using Google search:

Rank: DCount("*","tblExam"," ObtMrks >" & [ObtMrks])+1

It works as I need, BUT their is a problem that When this query assign same rank to 2 or more students, like Rank 6,6, the next Rank which the query generate is 8 instead of 7.