Multiple Report Pages?

  • Thread starter Thread starter Tom Lake
  • Start date Start date
T

Tom Lake

Here's a situation I've only encountered a few times but now it has me vexed.
I have a report with a subreport on it. When a person enters more data than
can be displayed on one page, I'd like the report to generate an extra page with
all the info from the main report and only those subreport items that didn't fit on
the first page. Example: A form has a customer name and address on the main
report and room for 10 orders in the subreport. If a user enters 12 orders for
that customer, I'd like two pages printed. Each page has the customer name and
address and the first page has 10 orders in the subreport but the second page only
has 2 orders in the subreport. It's just like with paper forms. If you have more
orders than will fit on one form, you write out a second form with the excess data.
So, my question is: Is there a way to do that in Access?

TIA

Tom Lake
 
Create a query that contains both the Invoice table and the InvoiceDetail
table.

Build a report based on this query, with a Group Header for the InvoiceID.

Set the Repeat Section property of the InvoiceID group header to Yes.
The section will repeat if the report flows onto the next page.
 
Back
Top