reversing records

[benbacardi]

how can i reverse the output of records in an access database using ASP so that the latest entry is at the top?

[Rob]

In your SQL query, use the following at the end:-
ORDER BY IDField DESC

[courtjester]

or you could always use something like this...

Code: Select all

recordSet.MoveLast
Do While NOT recordSet.BOF
blah blah blah
reocordSet.MovePrevious

Thats the ASP way, but the SQL way is much shorter