Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How to set total page number for each group?

Discussion in 'Information Technology' started by Hwee, Jul 28, 2006.

  1. Hwee

    Hwee
    Expand Collapse
    Guest

    Hi.. I have reset the page number for each group in a report. However, I am
    unable to calculate the total page number for each group.
    For example: For two groups, the first group got one page, second group got
    three pages. I want to set the page number to appear for first group: page
    1/1. For second group: page 1/2 and page 2/2. Pls help. Thanks.
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Settlement Leads To Peaceful Transition At Sikh Temple Breaking News Sep 10, 2016
    Sikhi Langar-Aid - Sikhs Have Set Up A 'Langar' In The ISIS Territory of Syria To Feed Refugees Sikh Sikhi Sikhism Oct 31, 2015
    A set back or a step forward Blogs Oct 17, 2015
    USA Sikh Cartoonist Sets Out To Fight Racial Bias Breaking News Mar 9, 2015
    India Who says we have skeletons only in our closets? Breaking News Aug 22, 2014

  3. fredg

    fredg
    Expand Collapse
    Guest

    On Mon, 5 Jun 2006 20:04:01 -0700, Hwee wrote:

    > Hi.. I have reset the page number for each group in a report. However, I am
    > unable to calculate the total page number for each group.
    > For example: For two groups, the first group got one page, second group got
    > three pages. I want to set the page number to appear for first group: page
    > 1/1. For second group: page 1/2 and page 2/2. Pls help. Thanks.


    See:
    "Printing First and Last Page Numbers for Report Groups "
    http://www.mvps.org/access/reports/rpt0013.htm

    Things to make sure of:
    1) Add a control to the page Footer that computes [Pages], i.e.
    = [Pages]
    You can make this control not visible if you wish.

    2) Add an unbound control to the Page Footer.
    Name this control "ctlGrpPages"

    3) Paste the code into the Page Footer Format event.

    4) In the code, change Me!Salesman to
    Me![Name of the control used to group by]
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  4. Hwee

    Hwee
    Expand Collapse
    Guest

    I tried the method. However, the result came out as page 1 of 1 and page 2 of
    2 when there is two pages in the group. The result should be page 1 of 2 and
    page 2 of 2. Pls help. Thank you =)

    "fredg" wrote:

    > On Mon, 5 Jun 2006 20:04:01 -0700, Hwee wrote:
    >
    > > Hi.. I have reset the page number for each group in a report. However, I am
    > > unable to calculate the total page number for each group.
    > > For example: For two groups, the first group got one page, second group got
    > > three pages. I want to set the page number to appear for first group: page
    > > 1/1. For second group: page 1/2 and page 2/2. Pls help. Thanks.

    >
    > See:
    > "Printing First and Last Page Numbers for Report Groups "
    > http://www.mvps.org/access/reports/rpt0013.htm
    >
    > Things to make sure of:
    > 1) Add a control to the page Footer that computes [Pages], i.e.
    > = [Pages]
    > You can make this control not visible if you wish.
    >
    > 2) Add an unbound control to the Page Footer.
    > Name this control "ctlGrpPages"
    >
    > 3) Paste the code into the Page Footer Format event.
    >
    > 4) In the code, change Me!Salesman to
    > Me![Name of the control used to group by]
    > --
    > Fred
    > Please respond only to this newsgroup.
    > I do not reply to personal e-mail
    >
     

Share This Page