Creating Totals for each COLUMN in a report

  • Thread starter Thread starter mkm
  • Start date Start date
M

mkm

I am creating a preschool enrollment chart report that has a column for each
day of the week - M-F - with a checkbox which indicates if the child is
enrolled for that particular day. On a report, I show each child on a row,
showing the columns for the days of the week. I then want to get a count
total of the "YES" responses under each day of the week. I can't figure out
how to get it to distinguish a different count for the VALUE of the field ..
I can only get it to count all the records in the group. Any help???
 
You can add a text box to a group footer with a control source like:
=Sum(Abs([YesNoFieldName]))
 
Back
Top