Article ID: 209778 - View products that this article applies to.
This article was previously published under Q209778
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
If you create a crosstab query that uses an implicit parameter [XXX] or a form reference in a WHERE clause (criteria), you may receive the following error message:
The Microsoft Jet database engine does not recognize '[XXX]' as a valid field name or expression.
A crosstab query dynamically generates column names. Therefore, Microsoft Access cannot tell whether [XXX] or a form reference is referring to a parameter or to a column name until after the query is bound.
When you build a graph, Microsoft Access uses a crosstab to build the data to graph. If the query is a parameter query, you have to define the parameters explicitly, as you would have to for a typical crosstab query.
To avoid this error, define [XXX] as an explicit parameter by adding it to the Query Parameters dialog box. To do so, follow these steps:
Steps to Reproduce the Behavior
For additional information about crosstab queries, click the article numbers below to view the articles in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/209218/EN-US/ )ACC2000: Error with Linked Crosstab Subform or Subreport
209143For more information about parameter queries, click Microsoft Access Help on the Help menu, type troubleshoot parameter queries in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
(https://support.microsoft.com/kb/209143/EN-US/ )ACC2000: Creating a Crosstab Query with Multiple Value Fields
Article ID: 209778 - Last Review: June 24, 2004 - Revision: 2.0