Can I create (open) a recordset not from a table, from another recordset in memory instead? Something like this:

Code:
'open recordset 1
rs1.Open "SELECT * FROM table",cn... (etc)
'open recorset 2 from the first recordset
rs2.open "SELECT * FROM rs1,... (etc)