Conditional based counting in reports

[Don]

I have a report that lists details of different quality assurance reviews.
The query and subsequent report lists all reviews including fields
[reviewID], [company], [ordernumber], etc. It also contains "yes/no" check
boxes for certain responses.

The report I am trying to compile must list each of these reviews with all
accompanying details, but at the end I want to summarize the numbers, but I
only want to count unique answers, e.g. how many reviews were done, how many
different companies involved, how many different order numbers, etc. If I
use a simple =count[reviewID] then I get the total number of values instead
of just the uniquely different values, even if I hide repeat values in the
properties setting for the control. Is there a different way to write the
"count" expression so as to include only uniquely different answers?

Additionally, is there an expression to use to count only the number of
check boxes that are checked in the affirmative? Becasue I need all of this
summary information on one report, I don't want to use multiple queries and
reports if possible.

Should I be trying to put the expression in the "control source" or is there
a better place to put it?

 

[Duane Hookom]

You can create running sum text boxes in group headers with control sources
of =1 to count unique group sections. You could also create additional totals
queries to join into your report's record source.

You can "count" yes/true values with a control source like:
=Sum(Abs([YNField]))