How to Sum in ASP pages

[nonprogrammer]

Hi,

I would like to sum the values of a field and I am not sure how to go about it.

<%=(Recordset1.Fields.Item("dollar_amnt").Value)%>

I tried this but did not work

<%=sum(Recordset1.Fields.Item("dollar_amnt").Value)%>

<%sum(Recordset1.Fields.Item("dollar_amnt").Value)%>

 

[Sheco]

Assuming that field dollar_amnt will always contain a numeric value you could do this:[tt]
TheSum = 0
Do While Not Recordset1.EoF
TheSum = TheSum + Recordset1("dollar_amnt")
Recordset1.MoveNext
Loop[/tt]


of course if the value could ever be Null or otherwise non-numeric you'd need a conditional test before attempting any arithmetic.

 

[nonprogrammer]

Sheco the field will always be numeric.

the way you describe it I should replace

<%=(Recordset1.Fields.Item("dollar_amnt").Value)%>

<%
TheSum = 0
Do While Not Recordset1.EoF
  TheSum = TheSum + Recordset1("dollar_amnt")
  Recordset1.MoveNext
Loop
%>

 

[Sheco]

If you only care about the sum and not the individual values then perhaps you could change your SQL so that only the one summed value is returned.

SELECT Sum(dollar_amnt) FROM SomeTable

 

[nonprogrammer]

I have to have it by each user. If I do the sql then every one will be able to see everyone earnings