How to position class students on report based on their total marks

[kstephen3]

Hi Pals
I am working a database that manages student's Records including marks for various subjects, but i would like to do the following on each of the students' report cards:
a) Display the marks for all the 12 subjects .This one i have done.
b) Display a total for all marks of each student.Done as well.
c) The problem is, i don't know how to display the position of each student on the individual report cards.I want to base this grading on the total marks obtained by each student in the same class.
Can any one help me on this? I will be very grateful.
Thanks

 

[Anakardian]

If you are using a report to display the results there is the option of sorting the students on the marks.
You can find this under the group and sort buton.

 

[kstephen3]

Thanks Anakardian, I have tried that before, but my problem is:
After getting the totals for each student, i would like to rank them in positions From the first one to the last one.I was thinking of using a VBA code in which i can pass the query containing these students' marks as a recordset, add the totals for each student,return a total against each student, and then sort this result using the totals.This can therefore be ranked with positions that are returned in calculated control on each report.But i just don't know how to do this.Could help me with such a code

 

[Trevor G]

Check out this link to see how ranking can be done

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

http://blogannath.blogspot.co.uk/2009/11/microsoft-access-tips-tricks-rank-every.html

http://allenbrowne.com/ranking.html#temptable