Runtime error 3075(missing operator)

[mbaddar]

Hi,

I've written a sql insert statement that is causing me a lot of problems. I keep getting a runtime error 3075, missing operator when I run the sql statement below. The message specifies the OrderNotes field. This is the message I'm getting:
Runtime error 3075(missing operator) in query expression:
"This order is to be shipped overnight and customer will receive 10% discount')'.

Here is my sql statement.
sql = "INSERT INTO InquiriesOrders(ClientID, OrderNotes)VALUES(" & ClientID & "," & "'" & OrderNotes & "'" & &quot"

Any ideas?
Thanks a lot.
MBaddar

 

[PaulBricker]

Try this:
sql = "INSERT INTO InquiriesOrders(ClientID, OrderNotes)VALUES(" & ClientID & ",'" & OrderNotes & "')"

That should do it assuming ClientID is datatype Number and OrderNotes is datatype Text.

Paul