访问表 - 语法错误（缺少操作员）在查询前pression [英] Access Form - Syntax error (missing operator) in query expression

问题描述

我在我创建了一个查询的形式收到一个语法错误。我创建的形式来限制访问变化记录。虽然试图在窗体上设置过滤器，我收到的所有属性我试图筛选的语法错误。我相信这已经是与缺少（）围绕内查询code中的内部连接，但什么是奇怪，我是，我可以过滤查询没有问题。下面是查询code：

I am receiving a syntax error in a form that I have created over a query. I created the form to restrict access to changing records. While trying to set filters on the form, I receive syntax errors for all attributes I try to filter on. I believe this has something to do with the lack of () around the inner join within the query code, but what is odd to me is that I can filter the query with no problem. Below is the query code:

SELECT CUSTOMER.[Product Number], SALESPERSON.[Salesperson Number],
SALESPERSON.[Salesperson Name], SALESPERSON.[Email Address]
FROM SALESPERSON INNER JOIN CUSTOMER ON
SALESPERSON.[Salesperson Number] = CUSTOMER.[Salesperson Number];

任何想法，为什么只是形式会产生语法错误，或如何解决这一问题？

Any ideas why only the form would generate the syntax error, or how to fix this?

推荐答案

我是能够通过进入设计视图的形式，并把[]周围的任何字段名称有空间很快修复它。我现在可以使用内置的过滤器没有关于语法问题的恼人的弹出。

I was able to quickly fix it by going into Design View of the Form and putting [] around any field names that had spaces. I am now able to use the built in filters without the annoying popup about syntax problems.

这篇关于访问表 - 语法错误（缺少操作员）在查询前pression的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！