ADO: Using Recordsets created in temporary memory

[Richard]

I have a Table that I created from a query. But
want to select only certain records from it based on some criteria. Th
selection is complex enough that I want to loop through the entire table
selecting some records from each group of similar records in the Table. On
way to do this is, after creating an initial recordset based on the entir
table, create a new recordset in memory, and append all the fields from th
original recordset. Then I can add only the records that fit my criteria i
order to build up the new recordset the way I want it. This is addressed bu
only partially in Litwin et al's Access 2002 Desktop, p.274.

 

[Richard]

This is actually a follow-up to the original message (below)

My question is, How can I append all the fields from the original recordset to the new recordset

Richar

----- Richard wrote: ----

I have a Table that I created from a query. But
want to select only certain records from it based on some criteria. Th
selection is complex enough that I want to loop through the entire table
selecting some records from each group of similar records in the Table. On
way to do this is, after creating an initial recordset based on the entir
table, create a new recordset in memory, and append all the fields from th
original recordset. Then I can add only the records that fit my criteria i
order to build up the new recordset the way I want it. This is addressed bu
only partially in Litwin et al's Access 2002 Desktop, p.274.