Results 1 to 2 of 2
  1. #1
    awoitte is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    2

    Order by a Grouped By Count

    In my report, I've grouped by Template_Id (left column), and counted all proposals (second column) based on what template_id it is under.



    How can I Sort/Order by the count? I can sort by all the column names but there is no name/listing for the count at the bottom of each group of proposals found (in red) in the report. -Attached-


    Click image for larger version. 

Name:	Report.jpg 
Views:	19 
Size:	109.9 KB 
ID:	34886

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,411
    Cross posted here https://www.access-programmers.co.uk...d.php?t=300683

    Please read this link about the etiquette of cross posting http://www.excelguru.ca/content.php?184

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Orders to Be Automatically Grouped Based on Order Date
    By hellocng in forum Database Design
    Replies: 2
    Last Post: 10-25-2017, 02:12 AM
  2. Replies: 2
    Last Post: 03-07-2016, 05:02 PM
  3. Order By Count
    By WickidWe in forum Queries
    Replies: 2
    Last Post: 12-30-2013, 01:31 PM
  4. Sum a Column grouped by Count
    By rlbordonaro in forum Queries
    Replies: 1
    Last Post: 01-16-2013, 10:38 AM
  5. Replies: 0
    Last Post: 03-26-2011, 09:59 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums