Technology Training Community

You can use parameter queries to allow users to enter criteria at run time. Parameters can be used in all types of queries. However, when you use them in a crosstab query you may receive an error message. The error message is a result of the crosstab query dynamically generating column names. This error can be corrected by adding the parameters to the Parameters dialog box.

To avoid the error add the parameter to the Parameters dialog box.
1. With your query in design view enter your parameter in the query design grid.
2. Click on Parameters on the ribbon located in the Show/Hide section.
3. Type the parameter under the Parameter column in the Query Parameters dialog box.
4. Select the appropriate data type from the drop down menu in the Data Type column.
5. Close the Query Parameters dialog box and run your query.