solarpunk Posted June 11, 2004 Share Posted June 11, 2004 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 More sharing options...
Fitch Posted June 11, 2004 Share Posted June 11, 2004 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 More sharing options...
solarpunk Posted June 11, 2004 Author Share Posted June 11, 2004 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. Link to comment Share on other sites More sharing options...
QuinTech Posted June 11, 2004 Share Posted June 11, 2004 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now