Inserting a Running Total Column?

[Ted Moore]

Dear Forum,

I am trying to set up a column total for a table.

Is there any reason I can't use VBScript instead of Java in Programming Example 32?

Basically, I have added a column (Expr1007) to a query for running total (rt).
The pertinent ASPdb looks like this:

x.dbSQL="Select ItemCode,quantity,ItemTotal,'rt' FROM qryViewCart WHERE SessionID=" & session("sessionID&#34
x.dbMagicCell= &#34;Expr1007,align=center,&#34; & <SCRIPT>rt=rt+#ItemTotal#</SCRIPT>

Any suggestions where to go from here? Thanks in advance, Ted.