Yes. I would like to know if I can extract from the result of a query an other recordset directly (for example a group by using the first recordset and the new subset.
Example I create a recordset myfirstrecordset by a query, I use it to:
calculate new variables using directly the recordset
extract part of these records with an other query to calculate other variables.
The reason is: "If I select records from a recordset already available I can avoid to select an other from the original tables that have a lot of records.
Thank you
Example I create a recordset myfirstrecordset by a query, I use it to:
calculate new variables using directly the recordset
extract part of these records with an other query to calculate other variables.
The reason is: "If I select records from a recordset already available I can avoid to select an other from the original tables that have a lot of records.
Thank you