checkbox "sum"?

[Anna C.]

I have a few checkboxes in my detail section in the report, but in the
end I would need to have some sort of summary of whether a checkbox
was checked or not. For example, there are five records, and only 1
checkbox is checked, I need for a checkbox in the footer to be
checked. Is there any function or formula that lets me do that? I put
in an expression, but it only reads the last record. I need for it to
cycle through all records and if at least box checked, mark it checked
in the footer. C'mon geniuses, help me please... Thank you very
much!

 

[Marshall Barton]

I have a few checkboxes in my detail section in the report, but in the
end I would need to have some sort of summary of whether a checkbox
was checked or not. For example, there are five records, and only 1
checkbox is checked, I need for a checkbox in the footer to be
checked. Is there any function or formula that lets me do that? I put
in an expression, but it only reads the last record. I need for it to
cycle through all records and if at least box checked, mark it checked
in the footer. C'mon geniuses, help me please...

Set the footercheck box's expression to something like:

=Sum([fieldname])

Make sure the fieldname is the name of the field in the
record source table/query and not the name of a control in
the report.