RunSQL UPDATE Error - 3075 Missing Operator

[Guest]

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)"

 

[Allen Browne]

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