ACC1x: Operators As Field Names in Query Cause Error Message

ID: Q98809


The information in this article applies to:


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 "<Table>.<Field>".


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 


REFERENCES

For more information, search for "logical operators" using the Microsoft Access Help menu.

Additional query words: queries


Keywords          : kberrmsg kbusage QryOthr 
Version           : 1.0 1.1
Platform          : WINDOWS 
Issue type        : kbinfo 

Last Reviewed: March 23, 1999