Can I create a prompt in a crosstab query?

A

AH

I want to generate a crosstab query based on user input either through a
prompt in the Criteria grid or through a Form and then entering an expression
in the Criteria grid. When I tried to do this Access would not allow it.
Does it mean that I have to go though a 2 step process to create a
pre-filtered table and then the crosstab?
 
J

jl5000

For the crosstab query, you have to declare the parameters, whether they are
input boxes or coming from a form, to do this:
-In the design view of the crosstab query click on parameters from the query
menu.
-Declare the parameter and type, use syntax like [Input Value] for Input
boxes and [Forms]![MyForm]![FieldName]
-Even if you are sending a pre-filtered query to your crosstab it is
necessary to declare these parameters wherever they are used.
 
Top