Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Groupings (2000)

    Hi, I am somewhat rusty on reports. Have fields; sales office, with sales staff and sales for each staff. My tables and query that will be the report source show a record for each sale made so I have sale1/office a/staff b/amount and so on. I need a summary report that just shows the sales office name once with the total sales for that office. Any guidance would be appreciated, a morning of frustration has proved fruitless.

    Thanks Darren.

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

    Re: Report Groupings (2000)

    If you use the Report Wizard to create the report, one of the steps lets you specify grouping levels. If you group by office, one of the later steps will offer a choice of displaying details+summary or summary information only.

    If you want to design the report yourself:
    - Specify the office field in the Sorting and Grouping window
    - Set Group Header and/or Group Footer to Yes.
    - Leave the Detail section empty, and set its height to 0.
    - Put the office field in the group header or footer, plus a text box with control source =Sum([amount]) where amount is the name of the field containing the sale amount.

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Groupings (2000)

    Thanks Hans, all coming back now!

    Cheers

Posting Permissions

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