I want to sort the date portion of the date/time field, desc, and the time portion of the date/time field, asc. Is there a simple method for me to be able to accomplish this? In other words, I want the most recent date to be sorted first, but within the date to be sorted in a normal 8am to 5pm sequencing.
I'm new to date/time fields in access (as a matter of fact, I just found out that all dates hold time references). If anyone has a good tutorial reference for date/time field questions, I'd appreciate the info.

You will want to add two new fields to your table and do an update query to take the Date/Time field, and split it into one Date field, and one Time field. Then don't store your data as Date/Time anymore.



mmcdonal

mmcdonal is right. But I don't think you need to go to the trouble of changing your table. Whenever you need that sort, just build fields in your query like this:

SELECT Table1.Datefld, Format([Datefld],"yyyymmdd") AS DateSort, Format([Datefld],"hh:mm:ss") AS TimeSort
FROM Table1
ORDER BY Format([Datefld],"yyyymmdd") DESC , Format([Datefld],"hh:mm:ss");

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org