to get sum of all Quantities

[scorpio]

hi
im new to asp. im stuck up with one problem.
im displaying "quantity" (values are extracted from the database). now i want to sum up the the quantity column & display it in a new column "total quantity".

what is the corresponding code for this in asp?
pls help.

[Dipti Singh]

Hi,

just do the following:

sum=0
do while not rs.eof
sum=sum+rs("fieldname")
rs.movenext
loop

' this will give u the sum of column values.
'store this value in ur database using update query :
eg: conn.execute "update........set sum='"&sum &"'"
'or using rs.update method if u want to do so or show on ur asp page.