MS Access Report page/report footer issue

Posted on 2009-04-17
Last Modified: 2012-05-06

I have a fairly standard access report with a report header & footer, page header & footer and a detail section.  The report is based on a query and works without problem except that if I put anything in the Report Footer section it appears immediately below the Detail section and above the Page footer and not where I would expect at the bottom of the report.

I have never come across this before - anyone have any idea what is happening?
Question by:kenabbott
    LVL 48

    Accepted Solution

    That is by design.
    Page Header and Footer follows the pages while Report Header and Footer wrap the detail section (and its groupings if any).

    LVL 46

    Expert Comment

    Hi Ken,
    The report footer always comes at the end of the report.
    If you want, you can add code that the page footer doesn't show on the last page.

    LVL 48

    Expert Comment

    by:Gustav Brock
    I think what Ken expected was that the report footer would be placed as the page footer on the last page. This is not the case, it is positioned as the last printed item of the report and is printed right below the item before whereever on the page that is placed.
    This is different from the report header which (normally) is positioned at the top of page 1.


    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now