report time sort order (1 Viewer)

Dick7Access

Dick S
Local time
Today, 17:36
Joined
Jun 9, 2009
Messages
4,197
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!
 

Dreamweaver

Well-known member
Local time
Today, 21:36
Joined
Nov 28, 2005
Messages
2,466
You need to use Sorting and grouping add a sort order on your date field.


mick
 

Dick7Access

Dick S
Local time
Today, 17:36
Joined
Jun 9, 2009
Messages
4,197
Oops! forgot db?
 

Attachments

  • DicksvitalsFromNew4doctorVA.zip
    52 KB · Views: 74

pbaldy

Wino Moderator
Staff member
Local time
Today, 14:36
Joined
Aug 30, 2003
Messages
36,118
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
Staff member
Local time
Today, 14:36
Joined
Oct 29, 2018
Messages
21,358
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

Top Bottom