Microsoft KB Archive/98809

{|
 * width="100%"|

ACC1x: Operators As Field Names in Query Cause Error Message

 * }

Q98809

-

The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1

-

SUMMARY
If you use logical operators as field names in a table and then create a query that uses any of these fields, you receive the following error message:

Syntax error in query expression &quot;.&quot;.

MORE INFORMATION
To correct this problem, open the table in Design view and change the name of the field listed in the error message to a name that is not one of the logical operators.

The following are logical operators:

  And, Between, Eqv, IIF, Imp, In, Is, Like, Mod, Not, Or, and Xor