Aggregate Report 1

[jeffshex]

I have a table with about 40-50 fields on it, the majority of them just enter yes or no for the text on it. I'm trying to figure out how to get the same kind of output that a CountIf does in Excel.
Do I have to create a report based of that table and add in a text box for each field that does a Count(IIF()) Function for each yes that I would like to count.
All in all I'm trying to get a count of how many fields were marked yes and get a percentage of that.

Ideas?
Thanks!

 

[dhookom]

You can use a text box in a Report or Group Header or Footer with a control source like:

=Sum(Abs([YourFieldName]="Yes"))

The above would count the number of records in your report where the field value was "Yes".

Duane
Hook'D on Access
MS Access MVP

 

[jeffshex]

Ok, I will piece it together as such.
Just wasn't sure the best way to approach.
Thanks!!!