Page totals in report

R

Remco

Can anyone help me with the following problem:

In MS Access 2000 I'd like to develop a report with the
following conditions:

- The report is an invoice. There can be very many ordered
items on the invoice. Each line describes an ordered
product with a remark under it. The remark can be nothing
or a few sentences, so it's unknows how much space each
product-line needs.
- At the bottem of each page there should be a page-total
of the amount of money the items on that page cost.
- The top of the next page should show the page-total of
the previous page.
- At the end of the report there should be a total-amount,
but always at the same position on the page (not at a
group-end).

All the items belong to the same group, so there's no
grouping on wich the page-total can be calculated. Maybe I
should first create a sort of dynamically build groups or
something, who "know" when the next page comes so the page-
total can be calculated. I don't know how to do something
like that. Or maybe there are other possibilities? Does
anyone know an answer?

Greetings,
Remco.
 

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

Top