Count number of checked checkboxes on a report

I have checkboxes on a report which in some cases are checked and some are not checked.  In the footer I need a count of the checked checkboxes.  What is the syntax for that textbox?  The checkboxes come from a table, the field in the table is named "Complete" and is a Yes/No field.  The checkboxes in the detail section of the report are named "chkbxComplete".

--Steve
SteveL13Asked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
try this

=sum(ABS([Complete]))

mx
0
 
Don ThomsonCommented:
Wouldn't using the =sum  give you the total number of checkboxes whether they are checked or not

Wouldn't you have to use something like count where [complete]=True
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
ABS converts the -1 (True) to 1. So, you are summing either a 1 or 0.  If 3 check boxes are True, then you get 3.

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.