I need to sum "True" check boxes in Access

[eclipse93081]

I need a way to sum check boxes in Access. On the database interface I have 3 boxes you can check; "Scheduled/Went On", "Scheduled/Did Not Go On", and "Not Scheduled". I have the boxes set up as "True/False" in design view so on my report it will assign either a 1 if true, or a 0 if false. I need a way to sum each category by itself so I can keep track of how many times each box is checked every month so that when I print out a report it will total the number of "True" checks is at the bottom.

Thanks!

[ADezii]

I'll show you how to Total Yes/No Fields for 1 Field ([Not Scheduled]) and you can duplicate the process for the other two. For the [Not Scheduled] Field:

1. Add a Text Box to the Report's Footer Section aligned to the [Not Scheduled] Text Boxes in the Detail Section of the Report.
2. Set Properties of the Text Box as needed.
3. Set the Control Source of the Text Box equal to the following:
   =Sum(IIf([Not Scheduled],1,0))
4. Repeat the process for the other Yes/No Fields.