Report totals from page to page.

  • Thread starter Thread starter Scott Viney
  • Start date Start date
S

Scott Viney

G´day All,

This is my first ever try to use Access and am finally at the report stage.
I have a report that writes out the data for a quote of items i.e. quantity,
product, packaging, price, total for item, etc.

I can get the report to display the grand total at the end of the report,
piece of cake. This is in the report footer and my column headings, plus
the quote number, and company details for the quote are in the page header.

What I would like to do would is have a subtotal at the bottom of each page
and then that subtotal value is brought over to the next page and so and so
on till the grand total. Is this possible??

Any help will really be appreciated, cheers,
Scott
 
G´day All,

This is my first ever try to use Access and am finally at the report stage.
I have a report that writes out the data for a quote of items i.e. quantity,
product, packaging, price, total for item, etc.

I can get the report to display the grand total at the end of the report,
piece of cake. This is in the report footer and my column headings, plus
the quote number, and company details for the quote are in the page header.

What I would like to do would is have a subtotal at the bottom of each page
and then that subtotal value is brought over to the next page and so and so
on till the grand total. Is this possible??

Any help will really be appreciated, cheers,
Scott
Click to expand...

See Microsoft Knowledgebase article
132017 ' How to sum a column of numbers in a report by page'
 
Back
Top