SUMM FIELD

[sal21]

'AGGIORNO CUMULO
SQL = "UPDATE DB_C SET DB_C.IMPORTO=DB_C.IMPORTO+" & IMPORTO & " WHERE DB_C.CARTA='" & CARTA & "'"
'Debug.Print SQL
'DoEvents
CONN.Execute SQL, , adCmdText & adExecuteNoRecords
'AGGIORNO CUMULO

Have erro in image....

possible causeses, please.

In effect i nedd to update existing value in IMPORTO+900

note:
The field IMPORTO have a Number Double
the var IMPORTO is dimensioned as Double
Initial value in filed IMPORTO is 0,00

[HansV]

Impossible to tell without seeing the database.