sticky ado question

What I'm trying to do is use data shaping on a connectionless recordset to group on a field for a report.

It's simple enough to pull off if you're using a connected recordset, because those have a command object, but my disconnected recordset has no command object, so how am I supposed to do the data shaping?

here's some code I'm trying to use:
*********************************************
With cmdDyn
.ActiveConnection = connDyn
.CommandType = adCmdText
.CommandText = " SHAPE APPEND(" _
& " NEW adInteger as unit, " _
& " NEW adBSTR as clerk_id, " _
& " NEW adInteger as unit, " _
& " NEW adDouble as prod_time, " _
& " NEW adInteger as claims_worked, " _
& " NEW adDouble as clms_hr, " _
& " NEW adInteger as corrected, " _
& " NEW adInteger as reviewed, " _
& " NEW adInteger as flds_hr) as command1" _
& " COMPUTE command1 by 'unit'"


End With
Set rsDyn = CreateObject("adodb.recordset")
rsDyn.Open cmdDyn
********************************************
I've tried with and without the APPEND in the shape command,
but I get a syntax error on the rsDyn.Open line either way.
Is it not obvious what I'm trying to do?