report time sort order

[Dick7Access]

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]

You need to use Sorting and grouping add a sort order on your date field.


mick

 

[Dick7Access]

Oops! forgot db?

 

[pbaldy]

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]

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.