Share via

Access: how do I make the Report Header to appear after the Page Header on the first page?

Anonymous
2023-06-07T01:19:24+00:00

Hi,

I created a simple database with some data and a report. In Print Preview, the Report Header appears before the Page Header on the first page. I want the opposite (Page Header, then Report Header). After all, the Report Footer appears before the Page Footer on the last page.

Thank you

Microsoft 365 and Office | Access | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Duane Hookom 26,820 Reputation points Volunteer Moderator
    2023-06-07T03:12:09+00:00

    Create a top level grouping on a constant and move your report header controls to the new header section. Make sure the new section does not repeat.

    2 people found this answer helpful.
    0 comments

Answer accepted by question author

  1. ScottGem 68,810 Reputation points Volunteer Moderator
    2023-06-07T12:57:13+00:00

    The order of the bands is not changeable. The purpose of the Report Header is to describe the report and it is designed to only show on the first page. It generally does not include much, if any, data.

    The Page Header shows at the top of every page and generally includes column headings.

    The Page Footer is generally used for the Page Numbering so it needs to appear at the bottom of each page.

    The Report Footer is generally used for summaries of the data in the report.

    While you can't change the order of the bands, you can use Grouping to replace those headers and provide more control.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest