Nisam Ja

Nisam Ja

  • NA
  • 5
  • 8.1k

sort report by Time (HH.mm), when in database time column is type of Text

Oct 9 2010 4:57 AM
I have to sort report table by column where times in Access database are entered as Text. There is a problem because my times are ordered as text, like 10.30, 11.20, 23.40, 7.10, 9.25, and I like  them to be ordered from morning to midnight (7.10, 9.25, 10.30, 11.20, 23.40). I'd like to know if it's possible to sort report in correct way without changing column type in database.

Answers (4)