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

[IngressBusiness]

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

 

[arnelgp]

it is because you are concatenating wrong fields:

Rank : DSum("Score ","ScoresT","[Pupilname] = '" & [PupilName] & "' And [Class] = '" & [Class] & "' And [Term] = '" & [Term] & "'")

 

[IngressBusiness]

So how should i approach it
Thanks

 

[CJ_London]

think you will find Arnel has provided the solution

 

[IngressBusiness]

Thanks alot C.J London

 

[CJ_London]

you should be thanking arnel

 

[IngressBusiness]

you should be thanking arnel

Sure ! thanks Arnel