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
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