Access 2010 - Report Footer

[PaulW]

I don't know how to search this forum for a possible answer to my queston. Please forgive me if the question has already been answered.

I have a report where I need to supply a report total. I would like the total to be at the bottom of the last page (sometimes the only page). My report footer is the next line after the last detail line. Are there any easy suggestions. I currently have no code for this report.

[HansV]

You have to use a little "trick" for this.

1) Make sure that the report has a report header and footer.
2) Place a text box in the report footer with control source =Sum([MyField]) where MyField is the name of the field that you want to sum.
3) Name this text box txtSum and set its Visible property to No.
3) Make sure that the report has a page header and footer.
4) Place a text box in the page footer with control source ="Page " & [Page] & " of " & [Pages]
5) If you'd rather not display the page number in the footer, you can set the Visible property of this text box to No.
6) Place a text box in the page footer with control source =IIf([Page]=[Pages],[txtSum],"")

[PaulW]

Hans,

Again you have come to my rescue. Thank you so much.