sum of check box

[Guest]

Hi,

I made a report from a query. In my report I have multiple check box
(yes/no). I would like to sum all the yes check box at the end of the report.
I tried

=Abs(Sum([name_of field]))

as well as

=Sum(IIf([name_of_field]=True,1,0))

and for both, I get the result on the report as ''yes''....???...

Any suggestion? Thanking you in advance!

Cheers,

Ka

 

[Pieter Wijnen]

Fix the format property of the sum control (xerox engineering?)

Pieter

 

[Guest]

Thanks!

It works.
--
Ka

Fix the format property of the sum control (xerox engineering?)

Pieter

Hi,

I made a report from a query. In my report I have multiple check box
(yes/no). I would like to sum all the yes check box at the end of the
report.
I tried

=Abs(Sum([name_of field]))

as well as

=Sum(IIf([name_of_field]=True,1,0))

and for both, I get the result on the report as ''yes''....???...

Any suggestion? Thanking you in advance!

Cheers,

Ka