Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Microsoft Access Report Reset Page Number On Report Footer

Posted on 2016-09-01
Medium Priority
Last Modified: 2016-10-22
On last group record in a access report, the report shows page 1 of 2, the last page of the report shows 2 of 2 in the report footer, how do I reset the page number on the report footer to  page 1 of 1
Question by:rjordanbots
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 85
ID: 41780463
Why would you consider the LAST page of a 2 page report to be page "1 of 1". If it's a separate report, then create it as such.

That said: If the Report Footer page is always one page, then just use a static Label with a caption of "Page 1 of 1"
LVL 26

Accepted Solution

Nick67 earned 2000 total points
ID: 41780469
I don't quite understand.
[Page] of [Pages] is known as a notorious liar.

On last group record in a access report, the report shows page 1 of 2,
Ok, how many pages are there actually
the last page of the report shows 2 of 2 in the report footer,
Because this suggests two
how do I reset the page number on the report footer to  page 1 of 1
Well, you have no control over [Page] of [Pages]

You can try to keep track yourself by tracking Page() and Retreat() events, but that's the same thing Access does and fails to succeed at.
You can try to put a header/footer in a logical place on the report with a PageBreak control in that fires when a section above it grows to be almost to big to fit on the page (which is what causes the lies)  but getting that right is very hard.
You can render the entire report hidden.  Code in the report footer can then put the value of [Page] in a variable outside the report itself.  You then close the report and use [page] of [ThatStoredVariable] -- but you are essentially rendering the report twice for each time it outputs.

Or forget that notoriuos liar [Page] of [Pages] and just go with [Page]

I don't know of any simple joy, myself.
LVL 52

Expert Comment

by:Gustav Brock
ID: 41781426
In the group header, set:

    Me.Page = 1

LVL 52

Expert Comment

by:Gustav Brock
ID: 41847074
No response from the questioneer, so delete.

LVL 26

Expert Comment

ID: 41847105

Whack it.
The author never replied to any suggestions, or clairified the issue.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

610 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