Sorting by Time

[jamesd]

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

 

[Douglas J. Steele]

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)

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.