Advanced Sort - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Advanced Sort

Michael Johnson

3 years ago

Is there a way to sort time with SQL where the start and end times are different than the normal day? For example, instead of sorting from 12am to 11:59pm, I'm trying to sort from 2:01am to 2:00am as the start and end of the days. So midnight, 1am and 2am would sort to the end of the list, not the top of the list.

	Michael Johnson OP @Reply 3 years ago
I answered my own question. I used an alias and an IIF function that added a day to anything earlier than the time I wanted, then sorted ascending. But if anyone has any other ideas, I'm always up for learning other methods.

	Richard Rost @Reply 3 years ago
You could add 2 hours to the value, sort it, then subtract 2 hours when you're done. :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View