Sorting by "Time"

[kenmostafa]

hi all :

i'm connecting to a Access2000 db file using data control
and datagrid control for showing ...
one of the field's contain a time Field
with the format hh:mm:ss AM/PM

using code , how can i sort the table by TIME ??

many thanxxx ...

[Swatty]

You can order the recordset on the field where the time value is stored.

Desc or Asc