I have a time field in my database which is an options box. Users just choose 9:00, 10:00, 11:00 etc...

How do I get it to sort properly?

Thanks!

Is this a select field with the options? If so, i'm suprised it's not displaying them in the order entered.

Have you by any chance searched the DBMan forums, or checked the FAQ noted below and searched for "time" to find any related threads?

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

hi - sorry I was not clear.

I have two fields. one is a date field. another field is a time field which i setup as a alpha option select field. The option select is working fine. the users chooses a time 9:00, 10:00 11:00, 12:00, 13:00, etc...

My questions is I want to view all records for a specific date SORTED according to the time field. This is where my7 problem is. Any help will be appreciated.

Thanks!

Are you calling up the viewing of the records by date using a link?

If so, you should be able to add &sb=<fieldnumber>

changing fieldnumber to the number of your time field and then add &so=ascend or descend depending on whether you want the earliest of latest times displayed first.

I'm not positive but you might need to change this to a 'numer' field rather than alpha, but check both ways to be sure.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

hi again-

Sorry - I do not think I am being clear. I have a alpha field setup. Users are inserting time in the format - 9:00 9:45, etc...

How can I sort this field properly?

thanks again!