if you are using SQL, you can use the "sum" function in the SQL..
something like:
set rowcount 0 select sum(thenumbers) as theSum from table
this will return you a field that will hold the sum of the numbers, so practically you can have 2 SQL's one to grab the numbers, and another for the summing, or you can combine them in one SQL that will return you both.




Reply With Quote