The Microsoft Access database engine does not recognize <name> as a valid field name or expression. (Error 3070)
The specified name is not a recognized field name or a valid expression. In a query, this error can occur if you enter a name that improperly refers to a database, table, or field.
Possible causes with Microsoft Access:
- You have a parameter in a crosstab query or in a query that a crosstab query or chart is based on, and the parameter data type is not explicitly specified in the Query Parameters dialog box. To solve the problem:
- In the query that contains the parameter, specify the parameter and its data type in the Query Parameters dialog box. And;
- Set the ColumnHeadings property for the query that contains the parameter.
- In any type of query, you have improperly referred to a database, table, or field. For example, this error can occur if you refer to a field named Salary in an expression, but you misspell the field name, such as