ASP + SQL2000 : request with COMPUTE SUM(xx)

[Bryce]

Hello,
this is the query :
select IdBC, DateBc, montantHT From Table_BC,
Table_LignesC where Table_BC.IdBC=Table_LignesC.IdBC order
by Table_BC.IdBC COMPUTE SUM(montantHT) by Table_BC.IdBC

I can acces to my selection (IdBC, DateBc, montantHT)
But how can i reach the famous sum ?
I've red that when you execute this kind of query it
returns 2 recordset
but i can't read the second.
Has someone already done this in ASP, or maybe could help
me ?

Thanks for your answers

[Raymond D'Anjou \(raydan\)]

Set oRst = oRst.nextrecordset

"Bryce" <bwattellier_NOSPAM@alris.com> wrote in message
news:007b01c38127$58f22e00$a401280a@phx.gbl...

> Hello,
> this is the query :
> select IdBC, DateBc, montantHT From Table_BC,
> Table_LignesC where Table_BC.IdBC=Table_LignesC.IdBC order
> by Table_BC.IdBC COMPUTE SUM(montantHT) by Table_BC.IdBC
>
> I can acces to my selection (IdBC, DateBc, montantHT)
> But how can i reach the famous sum ?
> I've red that when you execute this kind of query it
> returns 2 recordset
> but i can't read the second.
> Has someone already done this in ASP, or maybe could help
> me ?
>
> Thanks for your answers