Grand total sum on every page footer? 1

[inspiraller]

Is it possible to have a Grand total sum on every page footer?

 

[Trendsetter]

If the Grand Total you are after is the final total that will appear at the end of the report, then you can reference that value from the report footer to a page footer entry. This would be done by using Report_Format and coding the explicit fields.

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[inspiraller]

Thanks Trendsetter

I dont know exactly how to do this Report_Format

I can create a text box in the REPORT FOOTER which is the sum of all the jobs in DETAILS. Then hide this from being printed. With the label ReportSum

I can then create a text box in the PAGE FOOTER, but I dont know how to access that REPORT FOOTER. With the label PageRefOfSum.

But What do I put into Control Source to get the value from ReportSum?

 

[Trendsetter]

lets say:
Textbox in report footer is called RepJobSum
TextBox in Page Footer is called PagJobSum
In the On_Format of the Report Footer enter the code:

Me.PagJobSum = Me.RepJobSum
Leave the Control source blank (unbound)


Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[Trendsetter]

lets say:
Textbox in report footer is called RepJobSum
TextBox in Page Footer is called PagJobSum
In the On_Format of the Report Footer enter the code:

Me.PagJobSum = Me.RepJobSum
Leave the Control source blank (unbound)

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk