By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,940 Members | 614 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,940 IT Pros & Developers. It's quick & easy.

Ranking students based on semester and level of education

P: 1
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.

Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,419
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.