J
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.
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.