User input for Crosstab Query

  • Thread starter Thread starter dannyjoered
  • Start date Start date
D

dannyjoered

Is there anyway to have the user input criteria for a
crosstab query? When I try I get an error that says "The
Microsoft Jet database engine does not recognize '[Enter
Date:] as a valid field name or expression.

Any workarounds would be appreciated!
 
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
 
Thank You! That worked perfectly!
-----Original Message-----
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

[email protected] said:
Is there anyway to have the user input criteria for a
crosstab query? When I try I get an error that says "The
Microsoft Jet database engine does not recognize '[Enter
Date:] as a valid field name or expression.

Any workarounds would be appreciated!
Click to expand...
.
Click to expand...
 
Thanks John,
Just what I needed also.
Regards
Terry

John Spencer (MVP) said:
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

[email protected] said:
Is there anyway to have the user input criteria for a
crosstab query? When I try I get an error that says "The
Microsoft Jet database engine does not recognize '[Enter
Date:] as a valid field name or expression.

Any workarounds would be appreciated!
Click to expand...
Click to expand...
 
Back
Top