471,893 Members | 1,455 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,893 software developers and data experts.

Ranking students based on semester and level of education

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
May 11 '17 #1

✓ answered by NeoPa

Your Criteria paramater (3rd) would need to include something to ensure it only looks at items that match those fields required that you have values for.

1 698
NeoPa
32,470 Expert Mod 16PB
Your Criteria paramater (3rd) would need to include something to ensure it only looks at items that match those fields required that you have values for.
May 11 '17 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Richard Hollenbeck | last post: by
1 post views Thread by MichaelFord85 | last post: by
65 posts views Thread by Chris Carlen | last post: by
reply views Thread by Maciej Gawinecki | last post: by
reply views Thread by YellowAndGreen | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.