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.
 
Top