Counts in Report Groups

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chip - 25 Dec 2005 16:53 GMT

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

Reply to this Message

Duane Hookom - 25 Dec 2005 17:12 GMT

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.

Signature

Duane Hookom
MS Access MVP
--

> Hi, I am new to ACCESS but I am needing to count rows in a grouped report.
> Let me try and explain better:
[quoted text clipped - 14 lines]
> THANKS IN ADVANCE!!!!
> Chip

Reply to this Message