Querring a recordset?

[PORRASTAR]

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

[alex_read]

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

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

[gravyboy]

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

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