asked on

Totals Per Page

I am trying to show a total for each page in a report. The report is very basic, just showing line items for Purchase Orders in the detail section of the report. I'd like to see what the total of the items are on each page when the PO is several pages long. HELP!

THanks!

joekendall

In the Page Footer, you can add a textbox and set its recordsource to =SUM([MyFieldToSum]).

Joe

Member_2_991572

ASKER

Doesn't work. I get errors in the calculation.

joekendall

What errors?

Member_2_991572

ASKER

#ERROR is all it gives, no total. If you place the EXACT same unbound txt box on the report footer, it works fine and gives the total. So, the statement is correct, it just doesn't like being on the page footer.

joekendall

Here is the solution.

http://www.mvps.org/access/reports/rpt0004.htm

Joe

Member_2_991572

ASKER

I can do that and it works (already tried it) but I either have to do a running sum or just a total I don't see any way to just show the total for THAT specific page. I would have to reset the counter per page. Any ideas?

ASKER CERTIFIED SOLUTION

joekendall

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Member_2_991572

ASKER

JOe,

I assume I should create a textbox called txtPageTotal and it will display the value of m_total. Do I have to put anything in the control value of that txtbox or leave it unbound? It doesn't display anything at this point.

Thanks!

Mike

Member_2_991572

ASKER

I got it! THanks!

joekendall

Yes, name the textbox txtPageTotal. It does not need to display anything. Glad to help!

Joe