473,224 Members | 1,368 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,224 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 753
NeoPa
32,554 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

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

Similar topics

1
by: Richard Hollenbeck | last post by:
I'm building a table of grades report based on a crosstab query where students are in the rows and the activities are in the columns. The grades are in the body where the rows and columns...
1
by: MichaelFord85 | last post by:
I'm bulding a database of students and their yearly performances. I have a student table with all of their permanent information, and a academic performance table that has different fields...
65
by: Chris Carlen | last post by:
Hi: From what I've read of OOP, I don't get it. I have also found some articles profoundly critical of OOP. I tend to relate to these articles. However, those articles were no more objective...
0
by: Maciej Gawinecki | last post by:
Hello, Recently I've interested in quering XML document streams. They can be queried in keyword- based manner (non-structural queries), as the authors of the article "Semantic Search over XML...
7
by: mrsoft100 | last post by:
To all Members, I am keeping a database of students performance records using ms access 2003.In the table named student I have names, Admision number, marks of students per subject which are eight...
2
by: kevinlhamiltonsr | last post by:
INSERT INTO ( CC, HeldPayAccounts, ASG, , Command, OrderNo, , ) SELECT .CC, .HeldPayAccounts, .ASG, ., .Command, .OrderNo, . AS Expr2, (Select count(.) from as where ((. >= .) and (. = ...
10
by: Ben Cherry | last post by:
Hi I have created a tablein acess 07 with three fields; admno, name, and Mark/100. My problem is that i need to have a field with position of this students based on the marks i.e the one with highest...
6
by: swestoyz | last post by:
Hello there, I am fairly new to custom SQL statements in Access, so I'll do my best to communicate my request. I am being tasked with ranking people based on a set score. The tie breaker would...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

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.