Order By THEN order By

[christrinder]

Hello,

Is there any way to order the results by two different fields, i.e. like you would do in Excel, data sort by column A and then by column B?

Thanks in advance for any help.

Chris

[whammy]

ORDER BY field1, field2

default is ASC (ascending)

ORDER BY field1, field2, DESC

:D

[christrinder]

That simple then!? Thanks.