Totalling Check Boxes

  • Thread starter Thread starter springschick
  • Start date Start date
S

springschick

Here is what I hope is a simple question. I can count the total number of
boxes that are checked, but was wondering if there is a way to count the
boxes that are not checked? Any help would be most appreciated.
 
I knew it would be something simple. Thank you Karl.

KARL DEWEY said:
IIF([CheckBox] = 0, 1, 0)
then sum.
--
KARL DEWEY
Build a little - Test a little


springschick said:
Here is what I hope is a simple question. I can count the total number of
boxes that are checked, but was wondering if there is a way to count the
boxes that are not checked? Any help would be most appreciated.
Click to expand...
Click to expand...
 
Okay, I can get the IIF statement to work easily enough, but I cannot seem to
get the sum to work. It has been a while since I worked on this. I named the
field I created with the IIF statement Check Box Inverse. I wrote out the Sum
formula as =SUM([Check Box Inverse]). When I run my report, I enter my date
parameters, and a prompt comes up to enter Check Box Inverse. What am I doing
wrong???? Thanks for any assistance!

springschick said:
I knew it would be something simple. Thank you Karl.

KARL DEWEY said:
IIF([CheckBox] = 0, 1, 0)
then sum.
--
KARL DEWEY
Build a little - Test a little


springschick said:
Here is what I hope is a simple question. I can count the total number of
boxes that are checked, but was wondering if there is a way to count the
boxes that are not checked? Any help would be most appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Never mind - went brain dead. Used =ABS instead - Works fine.

springschick said:
Okay, I can get the IIF statement to work easily enough, but I cannot seem to
get the sum to work. It has been a while since I worked on this. I named the
field I created with the IIF statement Check Box Inverse. I wrote out the Sum
formula as =SUM([Check Box Inverse]). When I run my report, I enter my date
parameters, and a prompt comes up to enter Check Box Inverse. What am I doing
wrong???? Thanks for any assistance!

springschick said:
I knew it would be something simple. Thank you Karl.

KARL DEWEY said:
IIF([CheckBox] = 0, 1, 0)
then sum.
--
KARL DEWEY
Build a little - Test a little


:

Here is what I hope is a simple question. I can count the total number of
boxes that are checked, but was wondering if there is a way to count the
boxes that are not checked? Any help would be most appreciated.
Click to expand...
Click to expand...
Click to expand...
 
No, no it doesn't - it only worked on a few. Still need help. Thanks.

springschick said:
Never mind - went brain dead. Used =ABS instead - Works fine.

springschick said:
Okay, I can get the IIF statement to work easily enough, but I cannot seem to
get the sum to work. It has been a while since I worked on this. I named the
field I created with the IIF statement Check Box Inverse. I wrote out the Sum
formula as =SUM([Check Box Inverse]). When I run my report, I enter my date
parameters, and a prompt comes up to enter Check Box Inverse. What am I doing
wrong???? Thanks for any assistance!

springschick said:
I knew it would be something simple. Thank you Karl.

:

IIF([CheckBox] = 0, 1, 0)
then sum.
--
KARL DEWEY
Build a little - Test a little


:

Here is what I hope is a simple question. I can count the total number of
boxes that are checked, but was wondering if there is a way to count the
boxes that are not checked? Any help would be most appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top