Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2001
    Location
    Oakland, California, USA
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sort report by number of records in each group? (97 SR2)

    Is it possible to order the groups on a report by the number of records present in each group? I've created an application to help my manager keep track of "to do" items for the 15+ studies we have going at any one time. It's currently grouped by project name and sorted in ascending order. My manager would prefer to have it ordered by how many tasks exist for each group (figuring that the project with the greatest number of to-dos is most often the project that's the highest priority). Can this be done?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: sort report by number of records in each group? (97 SR2)

    You'll have to add a count by project calculation to the query and then use that in the sorting and grouping.
    Charlotte

  3. #3
    New Lounger
    Join Date
    Jul 2001
    Location
    Oakland, California, USA
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sort report by number of records in each group? (97 SR2)

    Thank you for the suggestion! I've been able to create a query that returns the records and fields I want. A little more time spent with the report, and I think I'll have what I need.

    Thanks again for the advice.

Posting Permissions

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