Page Summation

  • Thread starter Thread starter Treebeard
  • Start date Start date
T

Treebeard

I would like to show the amount of books sold that are listed in each page
of a multi-page report.

I tried putting a text box in the page footer with the data source
=Sum([Qty_Sold]) but it returns an error message . This text box works
everywhere else in the form except the page header or footer.

Thanks

Jack
 
Jack,

Regrettably report page totals functionality is not built in Access. To get
it you need to use some code in your report. Check out knowledge base
article 216311 on Microsoft's site (it refers to A2K; if you have a differet
version just do a search on the knowledge base with keywords "report page
total", selecting your version).

HTH,
Nikos
 
Nikos,

Thanks , it works.

FYI
I had tried a similiar method except I was executing the summation
statement in the detail_on_format event, not the Detail_On_Print event which
is what the MS site suggests. I often wonderred what the differences are
between those two report events.

I was getting all sorts of screwy numbers. It would work when there were a
few records on a page , but not when there were many records, sometimes.

The detail section of my report was set as not visible because I was just
displaying the summation of the detail, that is how many books were sold
during that month. Since it wasn't visible, I could not use Detail_On_Print
event. What I did was rearrange my query to return the summation rather
that performing the summation in the Bookcode (Primary Key) group footer
section. This way I set the detail section as visible and used the
Detail_On_Print event .

Thanks Again,

Jack


Nikos Yannacopoulos said:
Jack,

Regrettably report page totals functionality is not built in Access. To get
it you need to use some code in your report. Check out knowledge base
article 216311 on Microsoft's site (it refers to A2K; if you have a differet
version just do a search on the knowledge base with keywords "report page
total", selecting your version).

HTH,
Nikos

Treebeard said:
I would like to show the amount of books sold that are listed in each page
of a multi-page report.

I tried putting a text box in the page footer with the data source
=Sum([Qty_Sold]) but it returns an error message . This text box works
everywhere else in the form except the page header or footer.

Thanks

Jack
Click to expand...
Click to expand...
 
Back
Top