为什么我会收到“缺少操作员”错误?

发布于 2024-11-18 21:32:22 字数 225 浏览 2 评论 0原文

我不断收到相同的错误:缺少操作员。这段代码我看了三遍也没找到。有眼尖的人可以帮忙吗?

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

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)

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(2

蓝天白云 2024-11-25 21:32:22

我不确定“”
也许来自这篇文章,但将它们更改为“”:

WHERE ([Letter Status].[Letter_Status] = "Agreed" AND [Research].[Site] = 9)
   OR ([Telephone Status].[Details]= "Agreed" AND [Research].[Site] = 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)
绅刃 2024-11-25 21:32:22

通常它是一个拼写错误的表或字段名称、两个空格而不是一个、一个空格而不是“_”、任何丢失的字母或类似的东西。

在 MS Access 中创建一个新查询并将整个查询放入,然后运行它。 Access GUI 很可能会更详细地告诉您这里到底缺少什么。

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.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文