Parameter Queries and Crosstabs

[Cassie Pennington]

I am struggling to create a crosstab query in Access that can be
updated/opened with the option of parameters. Do you have any
suggestions?

 

[Tony]

Hi Cassie,

I've found that if you create a make-table query with your
parameters first it makes it a lot easier. Crosstabs can
be a little weird. This is what I do:

1. Create Make-Table Query with Parameters
2. Create cross-tab query with the table that you created
from step 1.

Hope this helps!

Tony

 

[Van T. Dinh]

I am not sure of the emphasis but the answers are:

1. Cross-Tab Queries are not updateable, i.e. you cannot
change / edit the data in the DatasheetView of the Cros-
Tab Query.

2. To use Parameters in Cross-Tab Queries, you MUST
declare the Parameters. In the DesignView of the Cross-
Tab, use the Menu Query / Parameters... to access the
Parameters Dialog where you can declare the Parameters and
their Types.

HTH
Van T. Dinh
MVP (Access)