RunSQL UPDATE Error - 3075 Missing Operator

R

R. Stutts

I am getting a Syntax error (missing operator) in query expression with this
code. Can anyone see the problem?

RunSQL "UPDATE Hoppers SET Hoppers.RelDate = #" & Indate & "#,
Hoppers.Destination = " & Dest & ", Hoppers.Comments = '" & Com &
"'WHERE(Hoppers.Car_Num = '" & Car & "') And (Hoppers.RelDate Is Null)"
 
A

Allen Browne

Test the arguments.
The SQL statement would be mal-formed in Dest was Null.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VSTO C# add in Outlook.Appointment error 0
Running SQL statements in VBA 4
trouble with QBF and multiple choices 0
Runtime 3075 3
Syntax error in SQL query 3
Delete record and Error 3075 2
Help! When running SQL statement string treated as expression - whatis the cure? 3
Error 3075 3

Top