Grand Totals at Top

[Mmattson]

I have written a report that

1) uses a counter field in a Group/Break section and counts the number of group breaks I have. (set as a running sum - overall)

2) uses a counter field in these same sections that counts the number of indivdual records that I am reporting. (set as a running sum - overall)

3) In the Report footer I total these. It works fine


Challenge:
I want to move these totals to the Report Header and get the same percentages. It is not working because it is only taking the values from the first break (which is 1 & [population] from first record]).

How can I move these numbers to the Report Header?

 

[Rich]

Set the control source of the textbox in the header to that of the footer, hide the one in the footer

 

[Mmattson]

I've tried this. It gives me no different result.

 

[Rich]

Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)
Me.Text55 = Me.Text53
End Sub
where Text55 is the header textbox, Text53 is in the footer

 

[Mmattson]

Couldn't wait. Tried it...it worked.