Resort an open recordset

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Dumay - 25 Jan 2008 17:06 GMT

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

Reply to this Message

J_Goddard - 25 Jan 2008 19:20 GMT

Hi -

You don't need a new query, but you do need to re-create the recordset using
SQL:

set rsdata = db.openrecordset("Select * from MyQuery order by Q2Score")

should work fine, if you want all the fields from the query.

John

>Hi All,
>
[quoted text clipped - 9 lines]
>
>John Dumay

Reply to this Message

John Dumay - 25 Jan 2008 19:28 GMT

Hi John,

Thanks for the input. Works a treat.

Regards,

John Dumay

> Hi -
>
[quoted text clipped - 20 lines]
> >
> >John Dumay

Reply to this Message