How to sort in ascending order first the date field then the time field on a report?

Posted on 2014-08-19
Medium Priority
Last Modified: 2014-08-19
I have a report named "Chart 1 - Events" that I am trying to have the Date field then the Time field sort in ascending order automatically when the report is opened.

The query works fine, however the report does not sort.
Question by:cssc1
  • 4
  • 3
LVL 75
ID: 40270996
In Reports, Access completely ignores any sorting in the underlying query if you have defined anything in the Grouping/Sorting dialog.

LVL 75

Accepted Solution

DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 2000 total points
ID: 40270998
Use the Grouping/Sorting dialog do define any required sorting.


Author Comment

ID: 40271296
What is the "Grouping/Sorting dialog" and where can it be found?
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks


Author Comment

ID: 40271306
Sorry, I found it.

Author Closing Comment

ID: 40271307
LVL 75
ID: 40271338
Just about to post :-)
LVL 75
ID: 40271341
Also ... remove the sorting from the query, because Access still (wastefully) does the sort :-)

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question