query work in Access IDE but not in SQL string vb 6.0

[sal21]

UPDATE ANAGRAFICA SET ANAGRAFICA.TOT_ASS = TOT_ASS+DSum("IMP_ASS","VERS_ASSEGNI","RAPPORTO='" & RAPPORTO & "'");

this query work in Acces IDE, but in SQL="UPDATE ANAGRAFICA SET ANAGRAFICA.TOT_ASS = TOT_ASS+DSum("IMP_ASS","VERS_ASSEGNI","RAPPORTO='" & RAPPORTO & "'")" have error:


"Dsum not recognized in ... ecc...)
Why?

Have a similar solution.
Tkx.

[isladogs]

UPDATE ANAGRAFICA SET ANAGRAFICA.TOT_ASS = TOT_ASS+DSum("IMP_ASS","VERS_ASSEGNI","RAPPORTO='" & RAPPORTO & "'");

this query work in Acces IDE, but in SQL="UPDATE ANAGRAFICA SET ANAGRAFICA.TOT_ASS = TOT_ASS+DSum("IMP_ASS","VERS_ASSEGNI","RAPPORTO='" & RAPPORTO & "'")" have error:
"Dsum not recognized in ... ecc...)
Why?

Have a similar solution.
Tkx.

Set a variable equal to value of your DSum then use that in your query SQL instead

[sal21]

Set a variable equal to value of your DSum then use that in your query SQL instead

tks bro!
But not completlly understand...
can you post the complete SQL, please.
Tks.

[isladogs]

First create a variable & define its type as Double, Long or Integer depending on whether your DSum value will be a whole number etc ...
So for example:

Dim dblSum As Double
dblSum = DSum("IMP_ASS","VERS_ASSEGNI","RAPPORTO='" & RAPPORTO & "'")

CurrentDB.Execute "UPDATE ANAGRAFICA SET ANAGRAFICA.TOT_ASS = TOT_ASS + " & dblSum & ";"