Sum af sum i ASP

hej

Jeg har en tabel der ser således ud:

    p      s    h
v    100  100    100  =  300
b    100  100    100  =  300
i    100  100    100  =  300

problemet er jeg skal have resultatet af 300+300+300

Nedenstående kode er for 100+100+100

TotalFld=0
tmpFld = x_v
If Not IsNumeric(tmpFld) Then tmpFld = 0
rs("V") = cDbl(tmpFld)
TotalFld=TotalFld+cDbl(tmpFld)

tmpFld = x_s
If Not IsNumeric(tmpFld) Then tmpFld = 0
rs("S") = cDbl(tmpFld)
TotalFld=TotalFld+cDbl(tmpFld)

tmpFld = x_H
If Not IsNumeric(tmpFld) Then tmpFld = 0
rs("H") = cDbl(tmpFld)
TotalFld=TotalFld+cDbl(tmpFld)

rs("Total") = TotalFld


TotalFld=0
tmpFld = x_B
If Not IsNumeric(tmpFld) Then tmpFld = 0
rs("B") = cDbl(tmpFld)
TotalFld=TotalFld+cDbl(tmpFld)

tmpFld = x_Sk
If Not IsNumeric(tmpFld) Then tmpFld = 0
rs("Sk") = cDbl(tmpFld)
TotalFld=TotalFld+cDbl(tmpFld)

tmpFld = x_Hfb
If Not IsNumeric(tmpFld) Then tmpFld = 0
rs("Hfb") = cDbl(tmpFld)
TotalFld=TotalFld+cDbl(tmpFld)

rs("Totalb") = TotalFld


TotalFld=0
tmpFld = x_I
If Not IsNumeric(tmpFld) Then tmpFld = 0
rs("I") = cDbl(tmpFld)
TotalFld=TotalFld+cDbl(tmpFld)

tmpFld = x_Ski
If Not IsNumeric(tmpFld) Then tmpFld = 0
rs("Ski") = cDbl(tmpFld)
TotalFld=TotalFld+cDbl(tmpFld)

tmpFld = x_Hifi
If Not IsNumeric(tmpFld) Then tmpFld = 0
rs("Hifi") = cDbl(tmpFld)
TotalFld=TotalFld+cDbl(tmpFld)

rs("Totalhifi") = TotalFld