Using sum function

[Nicholas Bell]

Hi

I'm trying to add two values together and then insert them into the table. My code is wrong, if you are able to help, please could you help to change it. Thanks Nick


scode = Request("scode")
ucode = Request("ucode")
fridge = Request("fridge")
outmech= Request("outmech")
prizes= Request("prizes")
pos= Request("pos")
comments = Request("comments")

SELECT SUM(`fridge`,`outmech`) AS `score`" &_
" COUNT(*) AS score"


strSQLUsers = "INSERT INTO `triindep` (`scode`,`ucode`,`fridge`,`outmech`,`prizes`,`pos`,`comments`,`score`) " &_
" VALUES ('" & scode & "','" & ucode& "','" & fridge & "','" & outmech & "','" & prizes & "','" & pos & "','" & comments & "','" & score & "')"