Sorting

bknight
BronzeLounger
Posts: 1391
Joined: 08 Jul 2016, 18:53

Sorting

Post by bknight »

I have a field thar is date time. I sorted it but the time sort is wrong. Is there a way to sort by day then time?
Top
User avatar
HansV
Administrator
Posts: 78513
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Sorting

Post by HansV »

A date/time field always sorts first on date, then on time within the date.
What result do you get?
Best wishes,
Hans
Top
bknight
BronzeLounger
Posts: 1391
Joined: 08 Jul 2016, 18:53

Re: Sorting

Post by bknight »

I didn't save anything, sorry.
Top
User avatar
Gasman
2StarLounger
Posts: 104
Joined: 22 Feb 2022, 09:04

Re: Sorting

Post by Gasman »

So sort again and post back the result?
Using Access 2007/2019.
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
Please, please use code tags when posting code snippets, click the </>icon.
Debug.Print is your lifesaver.
Top
bknight
BronzeLounger
Posts: 1391
Joined: 08 Jul 2016, 18:53

Re: Sorting

Post by bknight »

I didn't save anything.
Top

Return to “Access/SQL and other database applications”