Counting the number of yes for a report

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

Guest

There is a option our product has and I want to no how many have them say yes
to that option. I see that Grouping them in report wizard does that but it
doesn't let me group more than 3 subjects at a time. Any help would be great!

Thanks
Dustin
 
Dustin said:
There is a option our product has and I want to no how many have them say yes
to that option. I see that Grouping them in report wizard does that but it
doesn't let me group more than 3 subjects at a time.
Click to expand...


Assuming that the option is in a Yes/No type field, use a
text box in any group footer and/or the report footer with
an expression like:

=Sum(IIf(theoption, 1, 0))
 
Back
Top