checkbox in the footer area marked/unmarked

[Guest]

I need help with the checkbox at the bottom of the report to be either marked
on unmarked based on the checkboxes in the detail area. If all the checkboxes
are marked I want the Bottom Checkbox to be checked. If anyone of the
checkboxes is not marked I want the Bottom Checkbox to be blank. Any help is
appreciated.

 

[Scott]

put a hidden text field that says if check is true then 0 if not 1. Then
add the text field in your report footer. If the total is 0 then all checks
are true, if it is equal to 1 or more then you have atleast one negative

 

[Guest]

Add a check box and set the control source to:
=Sum(abs(YesNoField)) = Count(1)

 

[Guest]

Thank you guys, it worked just fine

Add a check box and set the control source to:
=Sum(abs(YesNoField)) = Count(1)