Parameters in a Crosstab Querie

[Jack Stoudt]

My CROSSTAB querie works and thus will print fine if I
enter "criteria" directly in the design mode, but that's
not very convenient. Efforts to prompt for parameters only
yields a message that MS Jet Database does not
recognize "[....]" as a valid field name or expression.
How else can I enter parameters? (No code, please)

 

[Duane Hookom]

You must enter the parameter data types by selecting Query|Parameters and
entering your exact parameters and then selecting their data type.

 

[Guest]

Thanks, I got the Cross Tab Query to work with 2 parameters passed via the Query-Parameter route. Now, how can I pass them to a report, where they define the two columns of data

----- Duane Hookom wrote: ----

You must enter the parameter data types by selecting Query|Parameters an
entering your exact parameters and then selecting their data type