Count of records where checkbox 1 is unchecked, checkbox 2 is chec
in [Reports]
|
Prev: Displaying date parameter on a multiple page report
Next: Count of records where checkbox 1 is unchecked, checkbox 2 is
From: EllenM on 24 Mar 2010 09:53 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
From: Marshall Barton on 24 Mar 2010 10:31
EllenM wrote: >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. Here's one way: =Sum(IIf(checkbox1 And Not checkbox2, 1, 0)) -- Marsh MVP [MS Access] |