Count Check Box

M

mandy84angel

I have a form (F1) which has a section that lists three check boxes (EL,
Admin, Other). On another form (F2), is it possible to count how many of
those three checkboxes are checked on all records in F1?

In F1, there is another checkbox (Corrected) which I would also like to
count how many records are checked on F2 in a separate textbox.

Thank you for your time!
 
W

Wayne-I-M

Create an unbound text box with this as the source
in the forms footer or header

=Sum(IIf([EL]=-1,1,0))+Sum(IIf([Admin]=-1,1,0))+Sum(IIf([Other]=-1,1,0))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create form with checkbox les that expand and collapse sections of the form? 0
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Creating a Search using a combo box and then creating a report. 4
list or combo box 0
Adding data to MS Access from csv file 0
Field referencing - Continous Form 1
Inaccurate count with code 6
Macro to count words in a section, excluding footnotes and end notes 1

Top