By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,661 Members | 1,311 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,661 IT Pros & Developers. It's quick & easy.

I need to sum "True" check boxes in Access

P: 1
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!
Sep 19 '08 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,607
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.
Sep 19 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.