DCount help

[Tom]

I am using access 2003. I have a table called AttendanceT with a yes no field
called INClass

I am generating an attendance report . I want to know how many times each
student has been absent and how many times they have been tardy. I tried
putting a text box on the report and using the syntax
=dcount("[student]","AttendanceT","[InClass]='False'")

but it is not working. I want to count the number of times each student has
been absent. Then I would like to count the times each student has been tardy

 

[Rick Brandt]

I am using access 2003. I have a table called AttendanceT with a yes no
field called INClass

I am generating an attendance report . I want to know how many times
each student has been absent and how many times they have been tardy. I
tried putting a text box on the report and using the syntax
=dcount("[student]","AttendanceT","[InClass]='False'")

but it is not working. I want to count the number of times each student
has been absent. Then I would like to count the times each student has
been tardy

You're not doing anything to specify a student. Also, no quotes around
false for a Yes/No field.


=dcount("[student]","AttendanceT","[InClass]= False and [student] = 'Some
Student'")

Looks to me like a Totals query would be better since DCount will only
give you one answer at a time.