Update query with two conditions

[MikeLeBen]

Do you see why I get a "Syntax error" when I try to run this SQL instruction?

UPDATE Clienti_Ricette
SET Residuo = Residuo - 46,48
WHERE Residuo >= 46,48 AND IDCliente = 472

The WHERE part gets highlighted.

 

[Brianwarnock]

Can we assume that the , is the Decimal indicator?

Brian

 

[MikeLeBen]

Right!

Since I'm running this from VBA with

mySQL = "UPDATE Clienti_Ricette " & _
                "SET Residuo = Residuo - " & sforo & _
                " WHERE [Residuo] >= " & sforo & _
                " AND [IDCliente] = " & Me.IDCliente
                Debug.Print mySQL
        DoCmd.RunSQL mySQL

and the variable "sforo" is the result of a DSum, how do I fix it?

 

[MikeLeBen]

I changed the variable types form currency to integers and that did the trick.

Thank you so much I keep forgetting of the little nuisances of conversion between EU and US notation.

Edit:
Actually, no, that means the values are truncated and rounded to integers :/

 

[Brianwarnock]

Happy to have helped, even if by default.

Brian

 

[MikeLeBen]

ok I solved this with the replace function.
Should anybody else be in the same waters I was in, check these links for refernece:
http://www.tek-tips.com/viewthread.cfm?qid=1600948&page=2
http://www.techonthenet.com/access/functions/string/replace.php