I'm using ASP/MS access/dreamweaver.
I have a table which contains two fields, one with the date and one with the time. The order is all mixed up. Right now my SQL orders the data according to the date.
"SELECT * FROM hilliardmicroschedule ORDER BY vardate ASC"
But I'm running into the problem that when the dates are the same the times are still all mixed up. Is there a way to alter the SQL so that it orders by vardate first and then orders by vartime. The resulting recordset should be ordered primarily by date and when the dates are the same it will order by time. I'm assuming the code would look something like this:
"SELECT * FROM hilliardmicroschedule ORDER BY vardate ASC (AND ORDER BY vartime ASC)"
You can see the problem on this page under the first schedule (hilliard micro-mini) where the date order is fine but the times are all mixed up.
Thanks for any help.