将过滤器应用于查询结果colum =查询表达式'xxx'中的语法错误（缺少运算符） [英] Apply filter to query results colum = Syntax error (missing operator) in query expression 'xxx'

问题描述

在创建新查询（保存之前）然后应用自动过滤器时，我总是会在查询表达式'xxx'中找到错误"语法错误（缺少运算符）"其中xxx是列的名称。

在解除错误后，我可以应用文本过滤器，它可以正常工作，但我没有看到自动过滤器列表框的项目。 / p>

但是，保存查询后，自动过滤器会填充值。有时需要运行快速查询并找到一些项目，而不会在之后实际保存查询。

我家用电脑上没有这个问题，只有我的办公室XP SP3笔记本电脑。

谢谢

Andre

解决方案

  嗨AndreUys，

感谢您发帖，我们很乐意为您提供帮助。

阅读完您的帖子后，我发现很难重现您的问题，所以您介意上传吗？您的文件到SkyDrive： http://www.windowslive.co .uk / skydrive  ，
以便我可以对您的问题进行进一步研究。顺便说一下，您的Access的版本是什么。 < span style ="font-family："Segoe UI"，"sans-serif";颜色：黑色; font-size：10pt">

由于我无法重现你的问题，我无法给你确切的理由，但我可以给你一些建议：

1.尝试从控制面板修复您的Office。

2.请检查语法是否正确，此类下面的线程也遇到错误"查询表达式中的语法错误（缺少运算符）"：

http://bytes.com/topic/access/answers/207676-syntax-error-missing-operator-query-expression

< span style ="color：＃0000ff"> http://en.allexperts.com/q/Using-MS-Access-1440/2008/3/syntax-error-missing-operator-1.htm

http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/fc888e1a-457e-41e8-b137-dc550874617f < span style ="font-family："Segoe UI"，"sans-serif";颜色：黑色; font-size：10pt">

我希望这些可以帮助你，并在你尝试后随时跟进。

最好的问候，

Upon creating a new query (before saving it) and then applying a auto filter, I always get error "Syntax error (missing operator) in query expression 'xxx'" where xxx is the name of the column.

After dismissing the error, I can apply a Text Filter, which works fine but I am not presented with the Auto Filter list box of items.

Once I save the query however, the Auto Filter populates with the values. Sometimes it is necessary to run a quick query and find a few items without actually saving the query afterward.

I do not have this problem on my Home PC, only my office XP SP3 laptop.

Thanks

Andre

解决方案

 Hi AndreUys,

Thank you for posting and we are glad to help with you.

After reading your post, I found it difficult to reproduce your issue, so would you mind uploading your file to the SkyDrive:http://www.windowslive.co.uk/skydrive , so that I can do further research about your issue. By the way, what's the version of your Access.

I can't give you the exact reason because of I can't reproduce your issue, but I can give you some suggestions:

1. Try to repair your Office from the Control Panel.

2. Please check whether the syntax is right, and such bellowing threads also encountered the error "Syntax Error (Missing Operator) in query expression" :

http://bytes.com/topic/access/answers/207676-syntax-error-missing-operator-query-expression

http://en.allexperts.com/q/Using-MS-Access-1440/2008/3/syntax-error-missing-operator-1.htm

http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/fc888e1a-457e-41e8-b137-dc550874617f

I hope these can help you and feel free to follow up after you have tried.

Best Regards,

这篇关于将过滤器应用于查询结果colum =查询表达式'xxx'中的语法错误（缺少运算符）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！