Parameter query within a crosstab query

L

Lyn

Is it possible?
Parameter query works but I cant base the crosstab query on the parameter
query
also wont let me use parameter eg between [start date] and [end date] as a
where condition in the crosstab query
 
J

John Spencer

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
 
A

Allen Browne

You can use parameters in a crosstab if you declare them.

In query design view, choose Parameters on the Query menu.
Enter the 2 rows in the dialog:
[start date] Date/Time
[end date] Date/Time

It is always a good idea to declare parameters anyway.

Well, okay, it's not a good idea for parameters on *Text* type fields since
Access handles them wrongly:
http://allenbrowne.com/bug-13.html
 
Top