Double Criteria using the Dcount Function (to Rank Student Marks Per term per Class)

IngressBusiness

New member
Local time
Today, 13:20
Joined
Aug 31, 2022
Messages
10
Hullo Every on
I would like you to help me find a solution , am trying to rank Positions of students marks Scores per term,
the students are in different Classes so the positions must depend on their Classes Per term
am using this Code but its Not working out
Rank : DCount("Score ","ScoresT","[Pupilname] = '" & [Class] & "' And [Class] = '" & [Term] & "'")

Thanks
 
it is because you are concatenating wrong fields:

Rank : DSum("Score ","ScoresT","[Pupilname] = '" & [PupilName] & "' And [Class] = '" & [Class] & "' And [Term] = '" & [Term] & "'")
 
So how should i approach it
Thanks
 
think you will find Arnel has provided the solution
 

Users who are viewing this thread

Back
Top Bottom