Welcome to SPN

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

Sign Up Now!

Quickie Question re counting pages in a Report

Discussion in 'Information Technology' started by c02homer@hotmail.com, Oct 31, 2005.

  1. c02homer@hotmail.com

    c02homer@hotmail.com
    Expand Collapse
    Guest

    Access 2003 / XP2

    I have a question that I'm sure the solution is simple and I just don't
    know how to do it.

    I have a report that groups by individuals. Each individual may have
    3,4,or 5 pages assigned to them. My problem is that I want the footer
    to reflect the number of pages per individual - not the total number of
    pages in the entire report. Jones Report - Page 1 of 3 instead of
    Jones Report - Page 1 of 150.

    Can someone help me with this, please???

    Thanks!!
     
  2. Loading...

    Similar Threads Forum Date
    Question About GGS Questions and Answers Aug 28, 2016
    Marriage And Discrimination Related Questions Blogs Mar 21, 2016
    Sikhi Questioning Faith Sikh Sikhi Sikhism Mar 3, 2016
    Entering into Sikhism: Questions on Reht Maryada. Blogs Oct 22, 2015
    A question about kes/hair? Blogs Oct 21, 2015

  3. fredg

    fredg
    Expand Collapse
    Guest

    On 30 Oct 2005 17:27:52 -0800, c02homer@hotmail.com wrote:

    > Access 2003 / XP2
    >
    > I have a question that I'm sure the solution is simple and I just don't
    > know how to do it.
    >
    > I have a report that groups by individuals. Each individual may have
    > 3,4,or 5 pages assigned to them. My problem is that I want the footer
    > to reflect the number of pages per individual - not the total number of
    > pages in the entire report. Jones Report - Page 1 of 3 instead of
    > Jones Report - Page 1 of 150.
    >
    > Can someone help me with this, please???
    >
    > 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