Counting Checkboxes in Access Report

[irosen516]

Hi. Lets say that i have a table that contains check boxes. My report lists all the checkboxes, and down in the page footer, I want to have a text box that counts the number of checked boxes. My checkbox name is called checkbox and i've tried many variations of =Sum and =Count and can't seem to get it to work. My textbox always ends up showing =Error when I run the report. Any suggestions?

Thanks.

 

[downwitchyobadself]

Have you tried this variation?

=Sum(Iif([checkbox]=True;1;0))

The problem with this is that you probably want a total just for the page in question. Access doesn't do this without a little more complexity than you might expect, but it does do it. This article from MS shows you how it works:

ACC2000: How to Create Page Totals on a Report

 

[irosen516]

When I try to paste your formula =Sum(Iif([checkbox]=True;1;0))
into a textbox in the page footer, I get an error message saying invalid syntax and it won't let me click off of the box. Any other suggestions?

 

[downwitchyobadself]

Oh sorry. That's because of my Euro-formatting. Usually I catch that...

Try this:

=Sum(Iif([checkbox]=True,1,0))