You can't Query a recordset, but you could probably

form a sql subquery in your Select string... ie:



rs.open "SELECT * FROM (SELECT field1,field2 from table2)"



> Is it possible to run SQL queries against Recordsets? e.g. (SELECT * 

FROM 

> rsObject) 

> In Foxpro I used to run SQL queries and store the results into a cusror. 

> Then I could do anything with this cursor including running an sql query