Hello. I have an Ms Access Database where i have studentname, ScoresperSubjects, TotalMarks, Semester(i.e.Semester 1,2 and 3), Class (i.e. Class 1, Class 2, Class 3 & Class 4),Rank(as per total marks).
I used DCount() function to display rank of each students based on TotalMarks i.e. =DCount("*", "tblExams","TotalMarks>[TotalMarks])+1.
The ranks works well. but the problem is that it combines all students in different Classes and rank them together. For instance Position is from Class 1...position 100 is from Class 3 and so on. I want to rank them differently based on their Classes and Semester period. Thanks,. Pliz help