Totalling Check Boxes

[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.

 

[KARL DEWEY]

IIF([CheckBox] = 0, 1, 0)
then sum.

 

[springschick]

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.

 

[springschick]

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!

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.

 

[springschick]

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

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!

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.

 

[springschick]

No, no it doesn't - it only worked on a few. Still need help. Thanks.

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

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!

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.