How to do a SELECT on a RecordSet

How would I do a SELECT on a ADODB.RecordSet?

I have created the recordset from an Oracle database using a Select
statement with a Group By. Now I need to Select from that result and
further Group By and Sum. The logic of the statements don't allow for
it to be one Select Statement as I need to use the first recordset as
well.

Any ideas? Please advise. Thanks in advance.

What are you trying to do that could not be accomplished in a single SQL
statement?. You can embed SELECT statements in a single nested SQL
statement.

--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
<a style='text-decoration: underline;' href="http://www.veign.com/vrc_main.asp" target="_blank">http://www.veign.com/vrc_main.asp</a>
--

"Bret" <Bret.Griswold.DeleteThis@goodrich.com> wrote in message
news:1107956138.160330.8250@c13g2000cwb.googlegroups.com...
 > How would I do a SELECT on a ADODB.RecordSet?
 >
 > I have created the recordset from an Oracle database using a Select
 > statement with a Group By. Now I need to Select from that result and
 > further Group By and Sum. The logic of the statements don't allow for
 > it to be one Select Statement as I need to use the first recordset as
 > well.
 >
 > Any ideas? Please advise. Thanks in advance.
 ><!-- ~MESSAGE_AFTER~ -->