Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running Total Problem

Status
Not open for further replies.

schase

Technical User
Sep 7, 2001
1,756
US
Hi all,


I have a page displaying filtered records from an Access 2000 database.

it is a repeated row type of display. Each line represents a deal total, I would like to also have a running total as each row repeats.

Where I have 4 columns add together via asp to a deal total. How can I loop through the rows adding each deal total together to get the running total?

I have this right after the repeat code.

<% Dim i, strPageTotal
For i = 1 to 15
strPageTotal = ((rsResults(&quot;fldSalePrice&quot;)&i)*.00245)
Next
%>

To no avail, there are two tables, the inner table repeats every 15 rows, and the second table repeats the whole page
until the inner table reaches EOF.

Wanted to get a per page total

Thank you for all your help &quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top