Counting Checkboxes

[Brandon]

I have a report where I would like to tally the total number of checkboxes that have been checked for each header. How would I go about setting up a textbox to convey this value for me?

IE:

HEADER
NAME INTERVIEWED?

Student1 [X]
Student2 [ ]
Student3 [ ]
Student4 [X]
Student5 [X]

Students Interviewed: 3 <- This value!

Suggestions?

-Brandon

 

[Rich]

Try =Sum(Iif([Checkbox]=True,1,0))

[This message has been edited by Rich (edited 07-31-2001).]

 

[Brandon]

Hmm. Not working, but i will play with it some more, and I might end up using a query to do the count and then getting the data from the query...

Thanks for the help!

-Brandon

 

[Carol]

Put the formula that Rich gave you within the Report Footer section and make sure that you substitute "Checkbox" with the actual name of your field.

 

[Brandon]

Great, got it working! I guess the placement in the footer was more important than I thought!!

Thanks to both of you!

-Brandon