Quick Question: Is it possible t

[Maker1]

Quick Question:

Is it possible to count which check boxes are marked true in a report? I have the check boxes populating based on what is written in a text box. I need to know how many of each are checked per page.

 

[SgtJarrow]

Add an unbound text box to the details section. Set the control source to:

IIF(Me![Checkbox]=True,1,0)

Set the RunningSum of this field to OverAll....

The last box on the report is your count.

****************************
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[dhookom]

To get a total in the report footer, just create a text box in the report footer with a control source of:
=Abs(Sum([YesNoField]))
If you truly need Page totals then consider the code at

http://users.bigpond.net.au/abrowne1/ser-11.html.

Duane
MS Access MVP