Results 1 to 3 of 3
  1. #1
    Topflite66 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Aug 2017
    Posts
    87

    Sorting after Grouping


    I have two sub-reports that have 2 levels of grouping and 1 sorting. I would like to sort the entire report by the Eq. Group but still keep the Model and Series grouping. I have tried just grouping by Model and then sorting by the Eq. Group but then I have the Series repeated for each Eq. Group line. I have also tried to add the Series grouping after the Eq. Group sorting but then the report shows multiple entries for the Series with individual entries for each Eq. Group. Is there a way to have the report still keep the Model and Series grouping but then adjust the Series order based on the Eq. Group sorting? Thank you.
    Attached Thumbnails Attached Thumbnails Unit Counts Sub Report Design View.jpg   Unit Counts Sub Report.jpg  

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    The sorting is to define sort order within each group.

    Use the first alternate solution you tried and set Series textbox HideDuplicates property to Yes.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Topflite66 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Aug 2017
    Posts
    87
    Quote Originally Posted by June7 View Post
    The sorting is to define sort order within each group.
    That's what I was afraid of. Thank you for your response.

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

Similar Threads

  1. Report Sorting and Grouping
    By singleton2330 in forum Database Design
    Replies: 4
    Last Post: 10-16-2014, 11:07 AM
  2. Sorting & Grouping
    By tanyapeila in forum Reports
    Replies: 6
    Last Post: 03-27-2014, 03:49 PM
  3. Sorting and Grouping in a report
    By Lisa Perry in forum Reports
    Replies: 3
    Last Post: 06-06-2012, 10:43 AM
  4. Replies: 11
    Last Post: 01-12-2012, 07:55 PM
  5. Sorting and Grouping
    By mduplantis in forum Queries
    Replies: 3
    Last Post: 07-29-2010, 12:31 PM

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