469,127 Members | 1,413 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,127 developers. It's quick & easy.

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 609
NeoPa
32,162 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
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.