Repeat the Report Header after Page Header / Details ends.

[Zandy12]

In MS Office, I built a report where Report Header has my company header, address info, account numbers, etc. and also the customer information (their address, contract number, POC, etc.) the header takes up about 4.5 inches then it begins the details of that customer orders sorted by date.

I suppressed the Report Header on page 2 so that details continue for that customers records. This has a Page Header showing only some of the customer information and their records continued from page 1 (so page header is only about an inch.)

I added a group footer and forced a page break after each group (Customer), so that the next customer is forced on a new page. So for example Customer1 ends up having 4 pages of records. Then the next Custumer2 begins on page 5. This works fine except it only shows the page header on page 5. I want to force the Report Header to display on page 5 and there after with each new customer (after the forced page break) and to return to the Page Header on page 6.

I have over 600 customers so I don't want to create 600 reports.

Is this possible?

 

[dhookom]

The Report Header section only renders once on the first page. If you want the information to repeat for each customer, move the controls to the Customer header.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016