[AccessD] Comma Decimal separator in UPDATE query

Hi Ervin

OK ... that would be the third and last option!

/gustav


> Solved with(the Price have 2 decmial places):
> DoCmd.RunSQL "Update tblOrderDetail set price=" & (NewPrice*100) & " where
> OrderNo=" & Order & " and ProductNo=" & Product
> DoCmd.RunSQL "Update tblOrderDetail set price=Price/100 where OrderNo=" &
> Order & " and ProductNo=" & Product