Sorting and Grouping

[turks67 via AccessMonster.com]

I have a report with a field name start Time. How do I sort this field by
order.

Now
6.30
7.0
9.0
2.30
1.30
12.30
11.30
9.30


Would like
6.30
7.0
9.0
9.30
11.30
12.30
1.30
2.30

 

[Duane Hookom]

Can you share your logic for this order or do we have to guess?

 

[KARL DEWEY]

Convert the text first like this --
AM_PM: IIFInt([Start Time]) < 6, "pm", "am")
Show_Time: Format(Int([Start Time]), "00") & ":" & Format([Start Time] -
Int([Start Time]), "00") & " " & IIFInt([Start Time]) < 6, "pm", "am")

Place the AM_PM field to the left of the Show_Time field in query design
view and un-select the Show check box. Select Ascending for the sort order
of both fields.

Then it will look like this and sort --
06:30 am
07:00 am
09:00 am
09:30 am
11:30 am
12:30 am
01:30 pm
02:30 pm