Sorting for Report by time

[Montez659]

I have created a simple db to log my time each day. I run a report that can show what I did by category however, whenever I sort by the date field (which includes time) it doesn't recognize the hours and minutes aspect and only sort by the date and then by record number. Is there something quirky that I need to do to sort by the time in ascending order?

 

[Montez659]

But for sorting you go to the actual SORTING AND GROUPING of the report - not the query.

Duh. Thanks!

Yep, that worked. It's amazing what the human mind can forget...