Symptom 1You receive an error message when you run a query that has a field name that begins with a double-byte arabic number. For example, if the field name contains two or more characters, such as "�PMonth", you receive the following error message:
Syntax error in query expression ' Table Name .�PMonth': Missing operator.
Invalid use of '.', '!', or '()' in query expression ' Table Name. '.
Symptom 2You use a table that contains some fields whose names begin with double-byte arabic numbers. Then, you create a query to select all the data for the field names that begin with double-byte arabic numbers. When you run this query, you receive the following error message:
Note This issue may also occur for objects other than tables.
To resolve the issue that is described in Symptom 2, see Resolution 2.
Resolution 1To resolve this problem, enclose the field name in single-byte square brackets ([ ]). For example, change the field name from 1Month to [1 Month].
Resolution 2To resolve this problem, use one of the following methods:
- Change any field names that begin with double-byte arabic numbers so that they do not use double-byte arabic numbers.
- Create and then save a new query.
- Create a new query that is based on the table. Name the new query Query1.
- Create a field that is named
TableName.* to the query.
Note Do not add any other fields except
- Save the new query.
- Use the new query to select the fields that you want.
Steps to reproduce the problem
- In Access, create a table.
- Define a field by using a name that begins with a double-byte Arabic number.
- Create a query that refers to the field in the table.
- Run the query.