I have a table (Student Fine) that contains the following fields:
Studend_ID
Date
Late Commer (Yes / No)
Shoe not polished (Yes / No)
Uniform not clean (Yes / No)
Uniform not Ironed (Yes / No)
Absent (Yes / No)
At the end of the month, I want to count the total number of Late Commer students, total students did not polish the shoes, Total students do not clean the uniform, etc
I am using the expression
=DCount("Student_ID","Student Fine","[Late Commer]= True")
In the result, all students counted, whereas I want to count specific students
can anyone help me?
I shall be grateful
Studend_ID
Date
Late Commer (Yes / No)
Shoe not polished (Yes / No)
Uniform not clean (Yes / No)
Uniform not Ironed (Yes / No)
Absent (Yes / No)
At the end of the month, I want to count the total number of Late Commer students, total students did not polish the shoes, Total students do not clean the uniform, etc
I am using the expression
=DCount("Student_ID","Student Fine","[Late Commer]= True")
In the result, all students counted, whereas I want to count specific students
can anyone help me?
I shall be grateful