Crosstab query error

  • Thread starter Thread starter Wendelin
  • Start date Start date
W

Wendelin

I have a query that has one prompt for CSS name driven by a form with an
unbound field so that the user can choose the name. The prompt works in that
query.

When trying to run the crosstab query based on the first query, I get the
following error:

"The Microsoft Jet database engine does not recognize
'[Forms]![frmCSS_Choices]![cmbCSS]' as a valid field name or expression.

SQL for Crosstab Query:
TRANSFORM Sum(qry_CT_GrvTotalCount.CountOfID) AS SumOfCountOfID
SELECT qry_CT_GrvTotalCount.CSA, Sum(qry_CT_GrvTotalCount.CountOfID) AS
[Total Of CountOfID]
FROM qry_CT_GrvTotalCount
GROUP BY qry_CT_GrvTotalCount.CSA
PIVOT qry_CT_GrvTotalCount.Month;
 
Crosstab queries must define the data type of each of their parameters (even
those indirectly involved in the query they use). From the query designer
under the menu Query (or, for Access 2007, at the end of the ribbon), ask
for Parameters, and fill the sheet with every parameter with their data
type. In your case, the name is [Forms]![frmCSS_Choices]![cmbCSS], but the
data type is your job to identify it :-)


Vanderghast, Access MVP
 
Back
Top