Search code examples
ms-accesspaginationreporting

ms access negative page numbers

I have an access report that generates 36505 pages (un filtered, and about half of each page is taken up by group headers and page headers) , though the footer at the bottom of the report page says "36505 of -29031". This looks like an overflow problem maybe, though I'm confused how it got the current page number of the last page OK, but failed to get total page count. Has anyone dealt with this before?

Solution

  • I found a clue on this page:

    http://www.sqldrill.com/excel/access-reports/695207-access-prints-negative-number.html

    But the expression wasn't 100% so I had to modify it:

    ="Page " & [Page] & " of " & IIf([Pages]<1,(32768-Abs([Pages]))+32768,[Pages])

    Page numbers appear to be correct now. :)