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))
 
Top