Sorting by Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database and I need to be able to sort the date field by time. It is a long format date field with the date followed by the time. Everything I try doesn't work. I set it to display only the time but it still goes about sorting by the dates first and then the time.
Any help would be appreciated
 
You need to use a query. In the query, add a computed field that only
contains the time, using TimeValue([YourDateField]). Sort by that computed
field.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



jamesd said:
I have a database and I need to be able to sort the date field by time.
Click to expand...
It is a long format date field with the date followed by the time.
Everything I try doesn't work. I set it to display only the time but it
still goes about sorting by the dates first and then the time.
 
Back
Top