Share via

Syntax Error When Filtering Form in Access

Anonymous
2019-03-19T19:43:58+00:00

Whenever I try to filter fields in a form in Access, I receive a "Syntax Error (missing operator) in query express 'NameOfField'". However, if I click "OK", I am still able to filter fine. Why does this happen?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-03-20T14:08:54+00:00

    Does this happen only when you try to filter on one particular field, or does it happen for all fields?  Does it happen for all forms, or just for one form?

    If it happens only for one particular field, I suspect that the field name (or possibly the value filtered by), which is obscured in the image you posted, may be peculiar in a way that causes Access to think that the constructed filter is not valid.  Are you sure that it "filters fine" despite the error?  Look at the form's Filter property after the filter has been applied and see if it looks correct.

    Is the field name or its filter criterion really private, such that you can't post them here?  It's hard to see whether my suspicion is correct without any evidence to test it.

    0 comments