Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report grouping (2003)

    I work for a school district - I need to print a report which shows all the date I've queried about each school showing the data for each school on a separate page.

    For instance, Maple Elementary School on one page, Live Oak on another, etc.

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

    Re: Report grouping (2003)

    Open the report in design view.
    Activate the Sorting and Grouping window.
    Enter the field that identifies a school in the Field/Expression column, and set Group Header to Yes.
    You can put the school name in this group header.
    Click on the group header in the report, then activate the Format tab of the Properties window.
    Set the Force New Page property to Before Section.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report grouping (2003)

    Thank you again - just for my own personal satisfaction - can't you do the same thing with the original query?

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

    Re: Report grouping (2003)

    You can't set page breaks in a query, if that's what you mean.

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report grouping (2003)

    I know you can't set page breaks, but I did think you could group and force each group to be separate????

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

    Re: Report grouping (2003)

    You can group a query on a field, but you can't force each group to be on a separate page. You need a report for that.

  7. #7
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report grouping (2003)

    Thanks again. Have a great day.

    Aunt Linda

Posting Permissions

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