Results 1 to 4 of 4
  1. #1
    lefty2cox is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    May 2013
    Posts
    163

    Sorting in report

    I have a simple invoice report I created that is based on a query. In the query, I'm soring by date. But for some reason, the report doesn't. It sorts in the order that the records were entered. I'd like the report to also sort by date. I should probably add that the query is based on a table that is sorted by date. I'm not sure why the report isn't following suit.

    Thank you.

  2. #2
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,566
    Hi

    In the properties of the Report set the Order By as follows:-
    Attached Thumbnails Attached Thumbnails Sort.png  
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,940
    Reports take no notice of source sorting

    It is all done in the report, in sorting and grouping.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #4
    lefty2cox is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    May 2013
    Posts
    163
    Thank you very much

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

Similar Threads

  1. Sorting in a Report
    By NewbyForAccess in forum Reports
    Replies: 19
    Last Post: 09-16-2015, 07:14 PM
  2. Report Sorting
    By B30 in forum Reports
    Replies: 1
    Last Post: 10-07-2014, 12:28 PM
  3. Sorting a report
    By tylerg11 in forum Reports
    Replies: 1
    Last Post: 12-14-2012, 03:25 PM
  4. Sorting and Grouping in a report
    By Lisa Perry in forum Reports
    Replies: 3
    Last Post: 06-06-2012, 10:43 AM
  5. sorting a field in report
    By Philangr8 in forum Reports
    Replies: 3
    Last Post: 08-26-2009, 05:38 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