help sorting time

[solarpunk]

Hello,

I was wondering if someone can help me figure out why the sorting of time schedule doesnt work for me. I have database to schedule appointment.

Here is a list i have for the time:

9:00 AM

9:30 AM

10:00 AM

10:30 AM

11:00 AM

11:30 AM

12:00 PM

12:30 PM

1:00 PM

1:30 PM

2:00 PM

2:30 PM

3:00 PM

3:30 PM

4:00 PM

4:30 PM

5:00 PM

5:30 PM

6:00 PM

6:30 PM

7:00 PM

7:30 PM

8:00 PM

8:30 PM

When i got set up as check box. I have summry report to print daily but when i go to sort out the appointment by time this is how it sort out

it show all the

9:00 AM

Than the

7:00 PM

Than the

11:30 AM

i am not sure what is triggering this to happen. the order is not correctly.

thank you,

Victor

[Fitch]

If you set it up as a checkbox, it is possible to click more than one time. So there may be more than one time in the field. That won't work right in a time field. It is defined with a type of "time," I hope? Since an appointment generally requires only one time, use radio buttons instead of checkboxes.

[solarpunk]

fitch,

Thanks, i mean to ssay radio button. i think it is the way the field was define. i didnt develop the database.

thanks, i will chekc.

[QuinTech]

Hi punk, if this is a text field, and you sorted descending, you got an expected result. Alphanumerically, 1 comes before 7 comes before 9, just like A comes before G comes before I.

To sort times appropriately, you will have to define the field as a Time field.

Does this help?

Jerry