Sort Sum in Access VB, I/O troubles

[superman75075]

I am using Access 2000. I am doing some calculations in a recordset that give me the following output:

Plan(=rs(0)) Gender(=rs(1)) C1(=rs(2)) C2(=rs(3))
------------ ----------- ----------- -----------
AAA1 Male 5 4
AAA1 Male 2 1
AAA2 Female 8 7

But I really need it to sum down to 2 rows:

Plan(=rs(0)) Gender(=rs(1)) SumOfC1(=rs(2)) SumOfC2(=rs(3))
------------ ----------- ----------- -----------
AAA1 Male 7 5
AAA2 Female 8 7

Is there any way to run a query against my recordset & use "Group By"? Or is there any way to create another record set that opens the first record set using a group by statement? Is there an array command that would do this?

Thanks!