report time sort order (1 Viewer)

Dick7Access

Dick S
Local time
Today, 14:32
Joined
Jun 9, 2009
Messages
3,620
Report doesn’t sort time properly. My (qryAlpha) sorts date and time properly. My (frmMain) datasheet view sorts time properly. My (qry3Months)sorts time properly, but my (rpt3Months) which has for its data source (qry3Months) puts the oldest time ahead of earlier time. (see Tuesday, October 22, 2019, 11:56 PM, then Tuesday, October 22, 2019 10:01 PM next. What am I doing wrong? Thanks!
 

MickJav

AWF VIP
Local time
Today, 19:32
Joined
Nov 28, 2005
Messages
2,007
You need to use Sorting and grouping add a sort order on your date field.


mick
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 11:32
Joined
Aug 30, 2003
Messages
34,235
I checked the db, and I assume you didn't see mick's post above. You just need to add the appropriate field(s) to Group & Sort on the ribbon.
 

theDBguy

I’m here to help
Local time
Today, 11:32
Joined
Oct 29, 2018
Messages
10,802
Hi Dick. Since reports have their own sorting facility, as Mick and Paul were saying, it ignores any sort order set in the query. So, you'll have to use the one in the report instead.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom