Results 1 to 3 of 3
  1. #1
    Alaska1 is offline Advanced Beginner
    Windows 10 Access 2007
    Join Date
    Oct 2010
    Posts
    55

    Sort on a Group Footer in Access Report

    I have a footer in my report totaling a count for an data field. I want to sort the report by the footer count to have the records with the highest count at the top of the report. How do I sort the report by a footer?

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,335
    you need another query, the main query,Q1
    then Q2 to do your count of Q1
    then the report uses Q2, and sorts on the count field , descending.

  3. #3
    Alaska1 is offline Advanced Beginner
    Windows 10 Access 2007
    Join Date
    Oct 2010
    Posts
    55
    Thank you!

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

Similar Threads

  1. Replies: 2
    Last Post: 12-08-2017, 11:17 AM
  2. Replies: 1
    Last Post: 09-08-2015, 11:02 AM
  3. Replies: 2
    Last Post: 12-21-2013, 02:09 PM
  4. Replies: 3
    Last Post: 06-28-2013, 01:38 PM
  5. Replies: 3
    Last Post: 02-17-2011, 10:19 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