Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    23

    Unanswered: Sort time of day

    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.

    Thanks
    Jim

  2. #2
    Join Date
    Nov 2004
    Posts
    23

    I believe I solved the problem

    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.

    Thanks
    Jim

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •