Count Checkboxes ticked in multiple forms
Posted on 2013-12-08
I have 6 forms which have about 10 questions each and roughly 4 tick boxes for each question.
I need to create a report which calculates the total number of times these tick boxes are clicked.
For example, if I have 100 records and for question 1 on the first form the 'Confirmed' tick box was ticked, lets say, 67 times, then in the report, for this question and this tick box, it will display the sum 67. Unfortunately, I have 6 forms and and lots of check boxes so I've got to do this for every tick box in every form :(
In the report, I have made the record source see all 6 tables and I've included all the tick boxes so the fields are available.
I use Access 2010.
some of the things I've tried adding to my report below in a text box.
Hope this makes sense