I created a form showing an employee's work at every hour through his shift. There is two shifts - 6am-2pm, 2pm-10pm, and 10pm-6am. The hours for the night shift were in correct order ie. 22:00, 23:00, 00:00, 01:00, 06:00. Then I created a query for a report to ask me to select which day I wanted. The report showed the hours of 6-2 and 2-10 in correct order, but for 10-6 hours, it showed the night and morning hours the other way round. All those shifts were based on a same day date. How can I get the correct order?

Thanks.