Check box count

[fixious123]

On my form in a text box Im using =Sum(IIf([Typhoid Complete]=True,[Typhoid Complete],0))

to count check boxes. The number is showing up right except its a negative. Any ideas as Im sure its just late for me. Thanks

 

[fixious123]

Problem solved

Abs() was the answer...

 

[fenhow]

Can someone explain Abs() was the answer? I am having the same problem.

Thanks

 

[fenhow]

Here is the solution. The Abs Function Wraps the expression.

=Sum(Abs(IIf([Satisfied]=True,[Satisfied],0)))