asp sum field value

[stpmtp]

Hello,
How can I sum the value of different fields

<if rsone ("sm")= rsone ("bn")then rsone ("sm").value = "3" else rsone ("sm").value = "0" end if %>

I have this for about 10 fields sm1,sm2,etc.

I would like to sum the value of sm1,sm2,sm3, etc.

how could I do this?

 

[monksnake]

do a for loop
(this will be jscript)

var totalValue = 0
for (a = 1; a < 10; a++) {
   if rsone ("sm + 'a' + ")= rsone ("bn + a + ")then rsone 
      ("sm + 'a' + ").value = "3" else rsone ("sm + 'a' + ").value = "0" end if %>
   totalValue += rsone("sm + 'a' + ")
}

<.