Subtotals by Page

T

TDS

I have a report that has an [hours] field. I have a totals field in the
report footer that calculates the total hours for the whole report (about
1200 records), but I also need a subtotal for each page. The grand total in
the report footer works fine, but any calculation I put in the page footer
returns an error. Any ideas what I might be doing wrong?

Terry
 
F

fredg

I have a report that has an [hours] field. I have a totals field in the
report footer that calculates the total hours for the whole report (about
1200 records), but I also need a subtotal for each page. The grand total in
the report footer works fine, but any calculation I put in the page footer
returns an error. Any ideas what I might be doing wrong?

Terry
Click to expand...

See Microsoft KnowledgeBase article:
132017 "How to sum a column of number in a report by page"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A03 - count in report footer gives me #Error? 0
Subtotals, not re-initializing 2
How to "copy" group running total to report footer? 3
Printing group totals in the page or report header 4
Running Sum 13
Report Footer Grand TL not appearing on one page report with colum 4
One and One-half Columns and Grand Total on Same Page (?) 3
Group last line of details and report footer 0

Top