Just totals on a report

[Jim]

I have a table which lists names of particpants by
district. Each participant can sign up for any number of
6 different sessions (Y/N box). I want to create a report
that just lists the the total number of names checked YES
for each session (not a listing of their names) and
hopefully sorted by District. What formula do I write to
do this? Do I need to do this in a query? I know how to
get the count in a report footer but that also prints all
the names, which I don't want.

any help would be appreciated.

 

[Fons Ponsioen]

The simplest would be to create a summing query, than you
can display the results by using the absolute value of the
summed results.
When you use the yes/no for input, the yes values are
stored as -1 and no as 0
so by summing the values you will know how many responded
yes for each question.
Hope this helps
Fons