Hi Brian, If the field datatype is text and the data values are stored as 13:00, 06:00, etc, you should be able to sort the records correctly by using the ORDER BY clause in your SQL statement - "order by 24hrtimeFieldName".
This won't work correctly if the time values are stored as 1:00, 13:00, 6:00, 7:00 Otherwise see if your database has a CAST or CONVERT function and convert the text field to a timestamp/datetime in your SELECT statement. Regards, Ben "Knott, Brian" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Does anyone know how to sort a query based on a 24 hour time. The field in > question is a test field not time field. At the moment it is sorting like > this > > 13:00 > 06:00 > 10:00 > 11:00 > > Mot sure why it want to put 13:00 above the rest > > > Brian Knott > QANTM Studio > Senior Database Developer > Ph (07) 30174331 > Mob 0407572127 > > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
