How to set parameters in Crosstab Queries?

[Ron Olds]

I've set up my Crosstab Query and get the exact results
desired. However, when entering parameters in the query
that I'm getting my information from, a message appears
when I run the query "The Microsoft Jet database engine
does not recognize <name> as a valid field name or
expression. (Error 3070).

This is what I entered into the "criteria" line of the
query: Between [Beginning Date:] and [Ending Date:]

This parameter has worked for all my other queries, but
not when it's used with a Crosstab Query. Hummmmm?

 

[John Spencer (MVP)]

First thing, with a crosstab query you MUST declare your parameters and if any
other queries are used in the crosstab their parameters must also be declared.

Open the query in design mode
Select Query: Parameters from the Menu
Fill in the EXACT name of the parameter in column 1
Select the data type of the parameter in column 2