Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-25-2019, 04:00 PM   #1
Dick7Access
Dick S
 
Dick7Access's Avatar
 
Join Date: Jun 2009
Location: Belleview, FL
Posts: 3,497
Thanks: 608
Thanked 41 Times in 39 Posts
Dick7Access is on a distinguished road
report time sort order

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!

Dick7Access is offline   Reply With Quote
Old 10-25-2019, 04:10 PM   #2
MickJav
Newly Registered User
 
Join Date: Nov 2005
Location: Margate
Posts: 1,007
Thanks: 73
Thanked 52 Times in 45 Posts
MickJav will become famous soon enough
Re: report time sort order

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


mick
__________________
All open code examples and free projects are only available from:

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Creating a new project then add styles to it download open code example from:

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
MickJav is offline   Reply With Quote
Old 10-25-2019, 04:11 PM   #3
Dick7Access
Dick S
 
Dick7Access's Avatar
 
Join Date: Jun 2009
Location: Belleview, FL
Posts: 3,497
Thanks: 608
Thanked 41 Times in 39 Posts
Dick7Access is on a distinguished road
Re: report time sort order

Oops! forgot db?
Attached Files
File Type: zip DicksvitalsFromNew4doctorVA.zip (52.0 KB, 7 views)

Dick7Access is offline   Reply With Quote
Old 10-25-2019, 05:00 PM   #4
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,390
Thanks: 13
Thanked 4,124 Times in 4,056 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: report time sort order

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.
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
The Following User Says Thank You to pbaldy For This Useful Post:
Dick7Access (10-25-2019)
Old 10-25-2019, 05:10 PM   #5
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,597
Thanks: 58
Thanked 1,446 Times in 1,427 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: report time sort order

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.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
Dick7Access (10-25-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Report Sort Order has changed BamaColtsFan Reports 0 04-13-2011 06:30 AM
Custom Sort Order in a Report? SusanCB Reports 7 03-10-2010 08:52 AM
Report not showing right sort order! sjl Reports 5 01-17-2008 05:21 PM
Report Sort Order Mac_Wood Reports 4 11-21-2006 02:24 PM
Sort order on report Lon425 Reports 1 02-16-2001 08:43 AM




All times are GMT -8. The time now is 06:27 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World