User input for Crosstab Query

[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!

 

[John Spencer (MVP)]

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

 

[Dan]

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

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!

.

 

[Terry]

Thanks John,
Just what I needed also.
Regards
Terry

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

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!