Sum Of Recordset

[tekyge]

Is there any way to have the asp page calulate the sum of a field like you do in VB? Example in vb you would
=sum([paid]) but in asp
<%= FormatCurrency(rs("Paid")) %>
how do you get asp to calulate correct?

 

[ChrisHirst]

you could let the SQL server handle it

SELECT SUM(paid) AS paid FROM table ;

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[Bullschmidt]

Or perhaps update cumulative variables after each row in a report. Then at the end of the report show these variables as the totals. The same concept can also be used for group totals by setting the cumulative variables back to 0 after each group. Example: InvSubtotalCum = InvSubtotalCum + InvSubtotal

Best regards,
J. Paul Schmidt, Freelance Web and Database Developer

http://www.Bullschmidt.com

Access Database Sample, Web Database Sample, ASP Design Tips