Jan 29, 2007 #1 stpmtp MIS Joined Jan 6, 2006 Messages 67 Location US Hello, How can I sum the value of different fields Code: <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?
Hello, How can I sum the value of different fields Code: <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?
Jan 29, 2007 #2 monksnake Programmer Joined Oct 14, 2005 Messages 2,145 Location US do a for loop (this will be jscript) Code: 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' + ") } <. Upvote 0 Downvote
do a for loop (this will be jscript) Code: 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' + ") } <.