Total Value from a Loop

hcweb · August 23rd, 2004, 11:47 AM

How can you get the total value acquired in a loop statement without knowing the number of records involved? i.e.:

Do While Not objRS.EOF
Response.Write objRS("value") & "<br>"
objRS.MoveNext
Loop

results in 3 records like so,
10
20
30

How can you total those figures after the loop to show only 60?

happygv · August 23rd, 2004, 01:15 PM

Code:

Dim TotVal
TotVal=0
Do While Not objRS.EOF
    Response.Write objRS("value") & "<br>"
    TotVal = TotVal + objRS("value")
objRS.MoveNext
Loop
Response.Write TotVal

This is how you could do that.

Cheers!

_________________________
- Vijay G
Strive for Perfection

hcweb · August 23rd, 2004, 02:56 PM

Worked like a champ! Your help is very much appreciated!

Thanks,
Chris