Counts in Report Groups

[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

 

[Duane Hookom]

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.