Select from a recordset

Hi all,
I have a ADO recordset that contains selection from some SQL Server table,
and I want to make selection from that recordset (not from table).
Is there any SQL Statement or method to do that ?

Nasreen

Try using Filter property.

Hi RhinoBull

Thanks for your replay
I want to select the data and sort depending on 3 or 4 fields in a recordset.
Is it is possible by filter method ?
Can u please assist with some sample codes for filter method ?

Nasreen