Re: Reset Page Number

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

AccessHelp wrote:

>I have a report containing a list of transactions for a client. Then the
>transactions are separated by project ID. When the users open the report for
>a client, it would print all the projects. The report is designed to group
>by each project.
>
>The way I want my page # on the report is "Page 1 of 3". I have no problem
>to reset the first page # ([Page]). How can I do to have the [Pages] show
>only a total page # for a project. Now if a client has 10 projects and if
>the total pages is 50, the report would show "Page 1 of 50", instead of "Page
>1 of 10" for each project.


Here's an article that describes how to do that:
http://support.microsoft.com/default.aspx?scid=kb;en-us;841779

--
Marsh
MVP [MS Access]
.

Relevant Pages

  • RE: Help Please!
    ... You can limit a query, report, or form to a specific date range by using a ... Microsoft Access MVP ... they still show as individual transactions. ... Every transaction has a client, of which, I have over 40. ...
    (microsoft.public.access.reports)
  • RE: Comparison Report based on a query of only calculations.
    ... Client number 004576 ... We got the report to work so that it sorts by Avg # of Cows and all the data ... Dave Hargis, Microsoft Access MVP ...
    (microsoft.public.access.reports)
  • RE: Comparison Report based on a query of only calculations.
    ... Dave Hargis, Microsoft Access MVP ... "Amy Schmid" wrote: ... Client number Client Name Avg # of Cows Production Livestock ... And you want them to appear on the report like: ...
    (microsoft.public.access.reports)
  • RE: Comparison Report based on a query of only calculations.
    ... "Klatuu" wrote: ... (my brain was wrapped up in a report I am working on at ... Dave Hargis, Microsoft Access MVP ... Client number Client Name Avg # of Cows Production Livestock ...
    (microsoft.public.access.reports)
  • RE: Comparison Report based on a query of only calculations.
    ... Dave Hargis, Microsoft Access MVP ... "Amy Schmid" wrote: ... Is there a way to have the data for each client in that filter to show up ... would allow you to present your report in the format you want. ...
    (microsoft.public.access.reports)