Creating a two-page report

[danikuper]

Hi, I've been using Access 2000 and am having trouble with the report I want to create.

I'd like to create a report that has two pages.

For example:

First page contains: Order ID, Customer name, Customer address, other customer info

Second page contains: Product ID, product name, quantity, total amount

Both pages have fields from a query that gives me all products ordered for that customer. The final result of running the report will be several two-page reports (each customer will be on a single page and the following page will have the products he ordered).

How do I do this? I've always used Access for one-page reports...

Thanks!

 

[mark curtis]

Group by customer, place the data in the detail and add a page break OR you could group by Customer then Orders, place the first lot of data in the Customer header and then set force new page before section on the Customer.