printing out a record set backwards

[riotman]

let's say that i have 4 elements in the record set. but instead of printing them out in order i want to go backwards like so..

4 3 2 1

how would one accomplish this? I've tried moving to the 4th element and using the moveprevious command but that doesn't seem to work.


any help? thanks.

[Rob]

you would need to use

rs.movelast
for myloop = rs.recordcount to 1 step -1
'do something
rs.moveprevious
next

.... or something very similar.

[Trebz]

You can do as Rob said, but bad form in my opinion. Better to put a proper ORDER BY in your SQL.

[riotman]

yeah, i ended up just ordering them by DESC in my sql statement. thanks for the help though.

[Rob]

Lol...... I could hit myself.