开发者

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].[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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜