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

  • Thread starter Thread starter Tommy Dhondt
  • Start date Start date
T

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
 
Tommy said:
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)
Click to expand...


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.
 
Marshall Barton said:
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.
Click to expand...

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 said:
Whoops. Sorry about that:
http://support.microsoft.com/default.aspx?scid=kb;en-us;132017&Product=acc97
Click to expand...

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
 
Tommy said:
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).
Click to expand...


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.
 
Back
Top