Crosstab Query Expressions

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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
 
Back
Top