DCount help

  • Thread starter Thread starter Tom
  • Start date Start date
T

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
 
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
Click to expand...

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.
 
Back
Top