开发者

Why am I getting the Missing Operator error?

开发者 https://www.devze.com 2023-03-17 22:24 出处:网络
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?

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].[Si开发者_StackOverflowte] = 9)


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)


Usually it is a misspelled table or field name, two spaces instead of just one, a space instead of "_", any missing letter or something like that.

Create a new query in MS Access and put the whole query in, then run it. The Access GUI most probably tells you more detailed what exactly is missing here.

0

精彩评论

暂无评论...
验证码 换一张
取 消