totale

[pagineasp2]

salve devo fare il totale di una colonna di una tabella, ma non so come fare in asp?
mi potete dare una mano
grazie

[optime]

SUM(nomecampo)

that easy!

[pagineasp2]

scusa ho fatto in questo modo ma non mi fa vedere niente a video, mi potresti dare un'occhiata per favore a questo codice?

Dim SuperTotale
SuperTotale=0

A1=rs1("DMC_IVR")
B1=rs1("TIMOTY_IVR")
C1=rs1("DWHC_IVR")

A2=rs1("DMC_web")
B2=rs1("TIMOTY_web")
C2=rs1("DWHC_web")

A3=rs1("DMC_asp")
B3=rs1("TIMOTY_asp")
C3=rs1("DWHC_asp")

colore1=""
colore2=""
colore3=""
colore ="#000000"


'//--------- CASO 1

if A1<>B1 and A1<>C1 then
colore1="red"
elseif A1=B1 and A1=C1 then
colore1="black"
else A1=B1 or A1=C1
colore1="black"
end if

'//--------- CASO 2
if A2<>B2 and A2<>C2 then
colore2="red"
elseif A2=B2 and A2=C2 then
colore2="black"
else A2=B2 or A2=C2
colore2="black"
end if
'//--------- CASO 3
if A3<>B3 and A3<>C3 then
colore3="red"
elseif A3=B3 and A3=C3 then
colore3="black"
else A3=B3 or A3=C3
colore3="black"
end if

SuperTotale=DMC_WEB+Rs1("Totale")
%>
<caption>



</caption>
<tr>
<td><font size="2" face="verdana">
<%response.write(rs1("DATA_INIZIO_SETTIMANA"))%> </font></td>
<td><font size="2" face="verdana"><%response.write(rs1("TIMOTY_IVR")) %>
</font></td>
<td><font size="2" face="verdana"><%response.write(rs1("TIMOTY_WEB")) %>
</font></td>
<td><font size="2" face="verdana"><%response.write(rs1("TIMOTY_ASP")) %>
</font></td>
<td><font size="2" face="verdana"><%response.write(rs1("totale"))%>
</font></td>
<td><font size="2" face="verdana"><%response.write(rs1("dwhc_IVR"))%> </font></td>
<td><font size="2" face="verdana"><%response.write(rs1("dwhc_WEB"))%> </font></td>
<td><font size="2" face="verdana"><%response.write(rs1("dwhc_ASP"))%> </font></td>
<td><font size="2" color="<%=colore1%>" face="verdana"><%response.write(A1)%>
</font></td>
<td><font size="2" color="<%=colore2%>" face="verdana"><%response.write(A2)%>
</font></td>
<td><font size="2" color="<%=colore3%>" face="verdana"><%response.write(A3)%>
</font></td>


<%