Total sum per page right below last record of each page in Access 97

[Tommy Dhondt]

Hi there,

I have a report with a query as record source. Query has 2 fields:
customer's name (e.g. "John Smith") and total order amount of that
customer (e.g. 169.35).

My report has a (very big) page header, detail and page footer section
and must contain maximum 10 records (detail section) per page.
The number of records (customers) can be anything. For example: 2
records (1 page with 2 records), 20 records (2 pages with 10 records),
35 records (3 pages with 10 records + 4th page with 5 records).

The problem I'm facing, is to have RIGHT BELOW the last record of each
page the sum of the total order amounts.
And, this sum may not be a running sum across all records/pages, but
must be a total sum PER PAGE. (For example: if 20 records with first
10 records having 10.00 as order amount and last 10 records having
100.00 as order amount. Then page 1 total sum must be 100.00 and page
2 total sum must be 1000.00)

Any help will be appreciated very much.
Thanks in advance.

Kind regards,
Tommy Dhondt

 

[Marshall Barton]

Hi there,

I have a report with a query as record source. Query has 2 fields:
customer's name (e.g. "John Smith") and total order amount of that
customer (e.g. 169.35).

My report has a (very big) page header, detail and page footer section
and must contain maximum 10 records (detail section) per page.
The number of records (customers) can be anything. For example: 2
records (1 page with 2 records), 20 records (2 pages with 10 records),
35 records (3 pages with 10 records + 4th page with 5 records).

The problem I'm facing, is to have RIGHT BELOW the last record of each
page the sum of the total order amounts.
And, this sum may not be a running sum across all records/pages, but
must be a total sum PER PAGE. (For example: if 20 records with first
10 records having 10.00 as order amount and last 10 records having
100.00 as order amount. Then page 1 total sum must be 100.00 and page
2 total sum must be 1000.00)

Here's an article that describes a good way to do that (use
the A97 version). There a different article for A2K, but it
uses an unreliable approach.

 

[Tommy Dhondt]

Here's an article that describes a good way to do that (use
the A97 version). There a different article for A2K, but it
uses an unreliable approach.

Hi Marshall,

It seems that you have forgotten to post (the link of) the article.
Can you please post it?

Thanks.

Best regards,
Tommy

 

[Marshall Barton]

It seems that you have forgotten to post (the link of) the article.
Can you please post it?

Whoops. Sorry about that:
http://support.microsoft.com/default.aspx?scid=kb;en-us;132017&Product=acc97

 

[Tommy Dhondt]

Whoops. Sorry about that:
http://support.microsoft.com/default.aspx?scid=kb;en-us;132017&Product=acc97

Hi Marshall,

Thanks. The information was very useful!

However, it only solves 1 of my 2 problems: i.e. total sum by page
instead of across all records.
I'm still challenged with the problem of having this total printed
RIGHT BELOW the last record of each page, opposed to the kb article
where the total is always printed at the bottom of the page (in the
page footer section).
For example: if I have 35 records, then the total on the last page
must be printed right below the last (35th) record (NOT at the bottom
of the page).

Any ideas how to accomplish this?
Thanks in advance.

Best regards,
Tommy

 

[Marshall Barton]

Thanks. The information was very useful!

However, it only solves 1 of my 2 problems: i.e. total sum by page
instead of across all records.
I'm still challenged with the problem of having this total printed
RIGHT BELOW the last record of each page, opposed to the kb article
where the total is always printed at the bottom of the page (in the
page footer section).
For example: if I have 35 records, then the total on the last page
must be printed right below the last (35th) record (NOT at the bottom
of the page).

It'll probably take some fiddling around, but I think you
can duplicate most(?) of the page footer code in the report
footer and use:
Me.Section(4).Visible = False
to hide the page footer on the last page.