Reverse Order of recordset

[briggsy79]

Hi all
Is there anyway to reverse the order in which you recordset is selected, currently it goes from lowest to highest, i want it to go highest to lowest.
Thanks

 

[sunaj]

Hi,

1) You could just move backwards in the recordset. This wont work if the recordset is bound to a control.

2) Use the sort property to sort the recordset as you please.

3) the hard way. Clone the recordset and loop backward through it while filling the new recordset with all the field values.


Sunaj

 

[elziko]

Or you could use a ORDER BY clause allowing you to sort your record acsending or descending inside an SQL statement used to open your recordset.

I know this isn't actually reversing an existing recordset but might do what you need.

elziko