Parameter in a Cross-tab query

[Vincdc]

Hello:
In a cross-tab query, I would like to insert one or two parameters. However, the MS Jet Database engine does not recognize [Myparameter] as a valid field name or expression. Any suggestion?
Thanks in advance!

 

[fredg]

Hello:
In a cross-tab query, I would like to insert one or two parameters. However, the MS Jet Database engine does not recognize [Myparameter] as a valid field name or expression. Any suggestion?
Thanks in advance!

In a Crosstab query you must enter the parameter and it's datatype in
the Parameter dialog box.
Click Query + Parameters

 

[Vincdc]

Hi Fredg:
Could you please give me an example?
Now, I use Like [MyParameter] & "*" as the parameter. When I run the query, it will show an error message "MS Jet Database engine does not recognize Myparameter as a valid field name or expression".
Thanks!

Hello:
In a cross-tab query, I would like to insert one or two parameters. However, the MS Jet Database engine does not recognize [Myparameter] as a valid field name or expression. Any suggestion?
Thanks in advance!

In a Crosstab query you must enter the parameter and it's datatype in
the Parameter dialog box.
Click Query + Parameters

 

[Duane Hookom]

Fred was referring to the menu selections while in query design. Then enter
parameters of
[MyParameter] text

--
Duane Hookom
MS Access MVP

Hi Fredg:
Could you please give me an example?
Now, I use Like [MyParameter] & "*" as the parameter. When I run the

query, it will show an error message "MS Jet Database engine does not
recognize Myparameter as a valid field name or expression".

Thanks!

However, the MS Jet Database engine does not recognize [Myparameter] as a
valid field name or expression. Any suggestion?