Access Form - Syntax error (missing operator) in query expression
forms, ms-access, syntax-error
Solution
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.
Problem
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?