Crosstab Query Expressions

[Guest]

How do I bring up a date range (where I enter the dates) in a crosstab query?
For example, I want to bring up a weeks worth of Labor Hours for our Drivers.

 

[John Spencer (MVP)]

If you mean you want to use a parameter query?

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

 

[laura]

I am trying to do something similar.. (see my other posts).. I need to pass
a parameter (date range) to the first query from which the crosstab is then
made, but I need to do this from an ASP page, probably as a variable.

Laura TD

 

[Duane Hookom]

If you have issues with ASP code, you should probably ask in an ASP news
group.