Parameter in a Cross-tab query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!
Click to expand...

In a Crosstab query you must enter the parameter and it's datatype in
the Parameter dialog box.
Click Query + Parameters
 
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!


fredg said:
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!
Click to expand...

In a Crosstab query you must enter the parameter and it's datatype in
the Parameter dialog box.
Click Query + Parameters
Click to expand...
 
Fred was referring to the menu selections while in query design. Then enter
parameters of
[MyParameter] text

--
Duane Hookom
MS Access MVP


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