ORDER By Date (SQL)

[vand_uk]

I have a query which i've ordered by date with:

ORDER BY status_reports.date;

But I want it to display in reverse order with most recent date first for example i want it in order of 18/sept/05 then 15/sept/05 then 10/sept/05.

im guessing i just need to add to the above SQL but im not sure what!

Can anyone help please

Thanks

 

[KenHigg]

ORDER BY status_reports.date DESC;

 

[vand_uk]

Oh i knew it'd be something simple.... thanks im learning more every day

 

[KenHigg]

Aren't we all