Count of records where checkbox 1 is unchecked, checkbox 2 is chec

E

EllenM

Hello,
I have a table with several check boxes. I'd like to place in the report
footer a count of the number of records where both conditions exist:
checkbox 1 is checked
checkbox 2 is unchecked.

Thanks in advance for your help.

Ellen
 
M

Marshall Barton

EllenM said:
I have a table with several check boxes. I'd like to place in the report
footer a count of the number of records where both conditions exist:
checkbox 1 is checked
checkbox 2 is unchecked.
Click to expand...


Here's one way:

=Sum(IIf(checkbox1 And Not checkbox2, 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

Sum of records with checkboxes unchecked 4
fake checkbox based off lookup column 2
how can I lock/unlock a range of cells depending on state of a checkbox? 4
how do i count "unchecked" boxes 4
Help counting multiple checkboxes in a form to make a total in a report 3
auto added checkbox 2
formating an unbound text box 1
Totalling check boxes 5

Top