Count in Report

[dette]

hi!

help! in my report i have the columns/fields Level1, Level2, Level3, Level4, Level5. entries in these fields are just check boxes. i want to count the no. of check marks in each level and put it at the end of each column. how do i do this?

i tried to use Count(Level1), etc... but it counts everything even if the level has no check mark...

thank you in advance for any help. need it badly...

 

[Taff]

Hi Dette,

Try putting this in the control source of the txt box you are using to count:-

=dcount("[your check box field]","[your tabel or query]","[your checkbox field] = true")

Taff.

 

[Rich]

=Sum(Iif([MyCheckbox],1,0))

 

[dette]

thanks!

thank you guys for the help! i used rich's solution and it worked.