How to assign positions on access report

[kstephen3]

Hi pals
Am working a student management database that keeps track of their records and marks obtained from 15 subjects.Each student has marks for 15 subjects.
I have a problem with assigning them positions on their reports in a given class.I would like to base this positioning on the totals of the subject marks.
someone help me.
Thanks!!

 

[vbaInet]

I'm failing to understand what you mean by positions on the reports. Can you elaborate with some examples perhaps.

 

[kstephen3]

80 students do exams for which they are awarded marks.For instance see the attachment.The data in this report comes from a query.It belongs to one student(named above) with his Id from the table(not shown herein). Each student in this class has a similar report.I would like to do the following on each report:
1)Add the the total of the average column on each similar report in this group(class) .2)Basing on this total for each student ,write his or her position in the class,out of the total number in there.The class is about 80 students.
3)From the grades column, i want also to add the best eight grades and display their total on each report.
Thanks

 

[vbaInet]

1. See the following link:
http://office.microsoft.com/en-us/access-help/summing-in-reports-HA001122444.aspx
2. This is a ranking exercise. It will need to be run in code and saved into a Student Ranking table before the report is opened.
3. What if a student is doing less than 8 subjects?