Parameters in a Crosstab Querie

  • Thread starter Thread starter Jack Stoudt
  • Start date Start date
J

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)
 
You must enter the parameter data types by selecting Query|Parameters and
entering your exact parameters and then selecting their data type.
 
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
 
Back
Top