Any idea how I can add fields to this sql statement:
strSQL = "UPDATE Products SET Cost = " & CDBl(strCost) & _
" WHERE ProductID = " & strID



I tried:
strSQL = "UPDATE Products SET Cost = '"& CDBl(strCost) & ", Week1 = " & CDBl(strWeek1) & " WHERE ProductID = " & strID


but to no avail. This is originally from:
www.4guysfromrolla.com/webtech/100199-2.2.shtml

Any thoughts much appreciated as this is driving me crazy!

Jim