Querring a recordset?

Hi
Does anyone have info on the sort property of a recordset and possibly an example showing how its used?
Thanking you in advance
PORRASTAR

The sort method sorts the recordset by the columns you specify :

Code:

---

rsTemp.Sort "Column2", "Column1"

---

Will make the recordset show the records in sorted by the second column, then the first, so :

1 | 3
2 | 2
3 | 1

becomes :

3 | 1
2 | 2
1 | 3

S'probably much better to order the recordset via the defining query . . . .

Code:

---

SELECT Field1, Field2, Field3 FROM tblTable WHERE Field9 = <SOMETHING> ORDER BY Field3, Field1

---