Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Sep 2003
    Location
    Ocean Gate, New Jersey, USA
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting and Grouping (A2K)

    Hello and Happy New Year,

    I have a report thats record source is from a query. In the report I need to either group or sort by seperate sizes so that the "total numbers of meters that do not meet bpu regulations" represents count of "meters numbers" by size, and I am unsure if my queries are wrong or am I not doing something incorrectly in the report. <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

    Any help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Sorting and Grouping (A2K)

    I won't have a chance to look at your attachment for a little while, but are you attempting to use the sorting and grouping feature of reports? Doing sorting and grouping in your query won't necessarily translate into the report correctly, so if you haven't turned on the sorting and grouping dialog for your report, try that and see if it will do what you want. I'll be back to the lounge later and take a look at your database.
    Wendell

  3. #3
    Star Lounger
    Join Date
    Sep 2003
    Location
    Ocean Gate, New Jersey, USA
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting and Grouping (A2K)

    Wendell,

    Thanks for your reply.

    Yes sorting and grouping are turned on in the report.

    Thanks for your interest.

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Sorting and Grouping (A2K)

    What seems to be wrong in the report?

    The counts reflect the number correctly.

  5. #5
    Star Lounger
    Join Date
    Sep 2003
    Location
    Ocean Gate, New Jersey, USA
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting and Grouping (A2K)

    Hello Pat,

    The report reflects a count of each column. Instead I need a count of each size in a column. As in column one there are 6 - 1 inch meters and 2 - 5/8 inch meters for a total of 8 and i need the 6 and 2 count.

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Sorting and Grouping (A2K)

    What I would do is to create a sub-report for each column that reflects just the totals (counts) by size of meters.

  7. #7
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Sorting and Grouping (A2K)

    I have shown a couple of subreports on the main report. This should give you an idea of what to do for the other one required.
    Attached Files Attached Files

  8. #8
    Star Lounger
    Join Date
    Sep 2003
    Location
    Ocean Gate, New Jersey, USA
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting and Grouping (A2K)

    Pat,

    Outstanding!

    Thanks for all your help.

Posting Permissions

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