I have a report based using a union query that I need to sort by a field ETA (Estimated Time of Arival). The field is formated in the table as medium time. The problem I am am having is that the sort want's to put the 1pm before 10 or 11 am. I'm not sure if the union query is eliminating the format. The report use to work before I made changes creating the union query. Any help would be appreciated.
In the sorting and grouping section of the report I used =TimeValue([ETA]) to change it to a serial number and then sorted it. It seems to have resolved the problem. Any other insight for the future may be helpful.