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("fldSalePrice"
&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 "Damn the torpedoes, full speed ahead!"
-Adm. James Farragut
Stuart
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("fldSalePrice"
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 "Damn the torpedoes, full speed ahead!"
-Adm. James Farragut
Stuart