[AccessD] Comma Decimal separator in UPDATE query

Ervin Brindza viner at eunet.yu
Wed Aug 18 03:33:59 CDT 2004


Hi,
I have a comma decimal separator and it isn't work in Update query. I want to open the Products form from "Order Details"(subform), modify the price, and get that new price on the subform. How can I force the Update query to accept it?
My query looks like:
DoCmd.RunSQL "Update tblOrderDetail set price=" & NewPrice & " where OrderNo=" & Order & " and ProductNo=" & Product
Many thanks in advance
    Ervin



More information about the AccessD mailing list