Jump to content

help sorting time


This topic is 7230 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 7230 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.