Forums

This topic is locked

ordering by date

Posted 16 Jan 2002 21:01:09
1
has voted
16 Jan 2002 21:01:09 David Behan posted:
Can anyone tell me the code, to order a recordset by the date. Programming in ASP and VBScript.

---------------------
David Behan - bmor.com

Replies

Replied 16 Jan 2002 22:49:18
16 Jan 2002 22:49:18 Owen Eastwick replied:
SELECT WhatEver, WhatEverElse, AndTheRest ORDER BY YourDateField ASC (for ascending)

Or

SELECT WhatEver, WhatEverElse, AndTheRest ORDER BY YourDateField DESC (for descending)

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Reply to this topic