Adding repeating regions

[sinistapenguin]

Hi

Does anyone know how to add together fields in repeating regions.

I have a number of repeating regions on a page and I want to display a total at the end.

Any tips gratefully received

Cheers

Sinista

 

[Cheech]

just add this before the repeat region in code view

<%
myTotal = 0
%>

And after the start of the region, which is something like:-

    <% 
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) 
%>

add

<%
myTotal = myTotal + Recordset1.Fields.Item(&quot;theFieldYouWishtoADD&quot;).Value
%>

Now when you want to display the total just put

<%=myTotal%>

Or you can do this with your select statement using &quot;Sum&quot; as in

SELECT SUM (salary) as &quot;Total Salary&quot;
FROM employees
WHERE fldName = 'A%'

Cheech

[Peace][Pipe]

 

[lebisol]

have your DB do the SUM vs. ASP.
WHY?
- IMHO ones SQL is executed (summed up) all u will be doing is navigating those records vs. "summing up" records (per page set) as u navigate.
Anyhow....nice & quick Cheeh!


> need more info?
:: don't click HERE ::