jerry jerry -4 years ago 57
SQL Question

Why am I getting the Missing Operator error?

I keep getting the same error: Missing Operator. I have looked over this code three times and cannot find it. Can someone with a keen eye please help?

WHERE ([Letter Status].[Letter_Status] = “Agreed” AND [Research].[Site] = 9)
OR ([Telephone Status].[Details]= “Agreed” AND [Research].[Site] = 9)

Answer Source

I'm not sure about that “”
Maybe is from this post, but change them to "" :

WHERE ([Letter Status].[Letter_Status] = "Agreed" AND [Research].[Site] = 9)
   OR ([Telephone Status].[Details]= "Agreed" AND [Research].[Site] = 9)
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download