Access Report: Counting Yes and No Fields

[literacyteacher]

Hi

I have a database that tracks students attendance. In a report, i having trouble with a formula to count "present" students

i thought it will be

=Count ([present]) but it is not working correctly. Please help!

Thanks in advance

Stephen

 

[dhookom]

Count() will return a count of all non-null values. Both yes and no are not null. Counting True values is the same as summing the absolute value of the field. Try:

  =Sum(Abs([Present]))

Duane
Hook'D on Access
MS Access MVP