ACC1x: Operators As Field Names in Query Cause Error Message

ID: 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 "<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