Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    Sep 2002
    Location
    Stafford, Staffordshire, England
    Posts
    585
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Another Report Grouping Question (xp)

    Hi Everybody

    I've tried to search for a solution but to no avail.

    I have a report which draws its data from a query. The query displays data about tutor group members. At the moment, the report displays one line (one pupil) on each page. What I require is the report to display the data for each tutor group on its own page. I'm sure I've done this before but I've not played with Access for a while.
    TIA.
    <font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Another Report Grouping Question (xp)

    Hi Rob,

    In the first place, have you specified a group header for the tutor group field in the Sorting and Grouping window?
    If so, you can click on the group header and set the Force New Page property to Before Section.
    Make sure that the Force New Page property for the detail section is set to None.

  3. #3
    4 Star Lounger
    Join Date
    Sep 2002
    Location
    Stafford, Staffordshire, England
    Posts
    585
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Another Report Grouping Question (xp)

    Hi Hans and thanks

    I've done as you suggested. Now, only one member from each tutor group is displayed per page. It's as if it's not allowing duplicate values of the tutor group. I hope that makes sense.
    <font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Another Report Grouping Question (xp)

    Could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.

  5. #5
    4 Star Lounger
    Join Date
    Sep 2002
    Location
    Stafford, Staffordshire, England
    Posts
    585
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Another Report Grouping Question (xp)

    Hi Hans

    Sorry about the delay. I've attached a stripped down version for your delectation.
    TIA.
    <font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Another Report Grouping Question (xp)

    Hi Rob,

    You have placed the text boxes in the group header. If you place them in the Detail section instead, you'll get the effect you want. See attached version.

  7. #7
    4 Star Lounger
    Join Date
    Sep 2002
    Location
    Stafford, Staffordshire, England
    Posts
    585
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Another Report Grouping Question (xp)

    <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>

    Thanks so much, Hans. I can't imagine what I was thinking, or even think what I was imagining. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    <font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •