Counts in Report Groups

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I am new to ACCESS but I am needing to count rows in a grouped report.
Let me try and explain better:

I have an inpection checklist that is filled out for each facility. the
Checklist has about 25 questions and I am tring to build a report that will
allow me to group by 'Facility' and show the total rows for that facility AND
to show me the total of questions for each facility that has been checked to
be "yes" on the forms check-box.

I have been trying to use the Facility Header of the rpeort and using
'Count' statements but the numbers seem to be running totals not just the
totals for the facility in the group. Any ideas?

THANKS IN ADVANCE!!!!
Chip
 
To count the number of Yes values in a YesNo field in a group or report
header or footer, use an expression like:
=Abs(Sum([YesNoField]=True))

If your table was more normalized, your reporting might be easier.
 
Back
Top