Parameter Queries and Crosstabs

  • Thread starter Thread starter Cassie Pennington
  • Start date Start date
C

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?
 
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
 
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)
 
Back
Top