Hi all, I need some help displaying the total cost of orders so far on a page. I'm working on a shopping cart using ASP MSAccess HTML etc, I simply want to display the Total cost in a table cell at the top of the page. At the moment I'm using VB script to calculate the total of each item in a cell at the end of the table by doing:

OrderNumber = Session("Order_ID")
Title = request.form("Title")
Quantity = request.form("Quantity")
Artist = request.form("Artist")
Price = ccur(request.form("Price"))
Stock_ID = request.form("Stock_ID")
Total = ccur(Price) * Quantity

sql = "INSERT INTO Cart (Order_ID, Stock_ID, Title, Artist, Quantity, Price, Total) VALUES "
sql = sql & "('" & Ordernumber & "','" & Stock_ID & "','" & Title & "','" & Artist & "','" & Quantity &"','" & Price &"','" & Total &"')"

Set rs = Server.CreateObject("ADODB.recordset")
sql = "SELECT * FROM Cart WHERE Order_ID = '" & OrderNumber & "'"

<td bgcolor="#CCCCCC"><div align="center"><%=rs("Order_ID")%> </div>
<td bgcolor="#999999"> <div align="center"><%=rs("Stock_ID")%></div></td>
<td bgcolor="#CCCCCC"><div align="center"><%=rs("Title")%></div></td>
<td bgcolor="#999999"><div align="center"><%=rs("Artist")%></div></td>
<td bgcolor="#CCCCCC"><div align="center"><%=rs("Quantity")%> </div></td>
<td bgcolor="#999999"><div align="center"><%=FormatCurrency(rs.Fields("Price" ).Value)%> </div></td>
<td bgcolor="#CCCCCC"><div align="center"><%=FormatCurrency(rs.Fields("Total" ).Value)%></div></td>

So my question is "What/how is the best way to display a total of the total column?"
Any help/links/suggestions would be greatly appreciated.