[thelist] ASP: 'Order By' question

[Casey Crookston]

Using Access 2000 in an ASP app.  Very simple Select statement:

"SELECT * FROM news ORDER BY date"

Naturally, it orders from the smallest date (oldest) to the largest (most
recent).  How do you get it to order it from largest to smallest?

TIA,

Casey