var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Sum of Yes/No field in page footer
Can anyone tell me how to sum fields in the "page footer" of a report? I have seven YesNo fields that I need to sum for each page of the report.
=Sum(IIf([YesNoField]=-1,1,0)) works in the "report footer" and in a "group footer", but it won't work in the "page footer".
place code into the OnFormat event of the page footer to tally up the check boxes that are true within that page footer.
ToTal = Abs(Me.Check1.value + Me.Check2.value + Me.Check3.value)