Resort an open recordset

[John Dumay]

Hi All,

In my cose i open a recordset called "rsdata" based on a query. In the
original query the data is sorted ascending on a field "Q1Score" which is
fine for the first bit of code. I want to now utilise the same data set but
now sort on field "Q2Score". How do I resort the recordset based on this
criteria without closing it - or do I need a new query?

Your assistance is appreciated.

Regards,

John Dumay

 

[John Dumay]

Hi John,

Thanks for the input. Works a treat.

Regards,

John Dumay