Results 1 to 3 of 3
  1. #1
    Ekhart is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jun 2016
    Posts
    80

    Sorting in Reports


    Is there a way to allow user specific sorting in reports? The users have limited access to what they can view, but there are a few fields I would like them to have the option to sort by. LastName, EntryDate, CategoryofCare.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I suggest you have a form with reports and selections available.

    Then select, push a button and the proper report in appropriate sort order is presented.

    See Martin Green's site for more info.

  3. #3
    Ekhart is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jun 2016
    Posts
    80
    Thanks, I have kind of altered the way I am doing this and now have an Option Button "SchedulerStatSelect" with 4 radio buttons in it indicating the field to sort by. I wanted to have it so one of the buttons is selected and then a button for the desired report is run. For instance if they select 'Last Name' radio button and then click on the 'Routine Report' command button, it would run the Routine Report that is sorted by last name.

    Edit: Figured it out using Cases Now if only I could stop being blind and figure out how to mark this as solved
    Last edited by Ekhart; 08-10-2016 at 08:21 AM.

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

Similar Threads

  1. Reports not sorting properly
    By Nick Lingenfelter in forum Reports
    Replies: 10
    Last Post: 02-26-2013, 06:38 PM
  2. sorting reports
    By nashr1928 in forum Reports
    Replies: 2
    Last Post: 04-03-2012, 11:59 AM
  3. Replies: 11
    Last Post: 01-12-2012, 07:55 PM
  4. Sorting in Reports
    By tfanara in forum Reports
    Replies: 1
    Last Post: 08-04-2011, 07:30 PM
  5. Field Sorting on Reports
    By netchie in forum Access
    Replies: 5
    Last Post: 07-25-2011, 11:45 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