Re: Reset Page Number



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: what to do it illegal activity found during pen-test
    ... If you discover illegal activity you have an obligation to report this to ... If you choose to report this to your client and let them deal with it you ... Download FREE whitepaper on how a managed service can ...
    (Pen-Test)

Quantcast