recordset rows to new recordset

[pb21]

I have some sql and have created a recordset. The data needs further refining so question is how do i pass that recordset data to the new second recordset for processing within second recordset sql.

re phrase similar to creating a new query in grid and refering to a prvious query. I hope i can achieve this without saving to a table and then doing something else.

regards
peter

 

[MarkK]

I'd refine the SQL completely before opening a recordset. You can write a query on a query, and that's where you want to refine your data access. Once you have it right, then open the recordset.

 

[pb21]

thanks lagbolt

good guidance and objective achieved

 

[tembenite]

I'd refine the SQL completely before opening a recordset. You can write a query on a query, and that's where you want to refine your data access. Once you have it right, then open the recordset.

Can you give an example?