If I already have a recordset called rs but I want to run a query on
that recordset. How do we go about it using ADO ...

for example in DAO I think it was: set rsNew = "select * from " &
rs.name &  "where Mydate = '01/01/99'"

Thanks for the help
Clyde