Do you have a Field that is a Date Field?
Do you have a Field that is a Time Field?
OR do you have a field that is a TimeStamp?
Home > Designing and creating databases > Creating a database > Defining database fields > Defining timestamp fields
When you do a sort on the Date field (ascending) and second the Time field (ascending) under theRecords Menu, what order do you get?
In Table View Sort records Click a column heading.Or, select one or more columns, right-click (Windows) or Control-click (Mac OS) to display the shortcut menu, then choose a sorting order. If you select multiple columns, the order of the columns (left to right) determines the sort order.Note You must have Sort data when selecting column selected in the Table View Properties dialog box. See Setting up form, list, and table views for a layout.
A more complicated solution
Easy Sorting of List Views, part 1