Crosstab Query with Parameters

[Scott Viney]

Hey All,

How do I create a crosstab query with parameters. I want the user to type
in a date that will be the start of the seven days for the week following
that date. So that it will then report jobs and how much time for each on
each day.

At the moment I have the crosstab query but it creates an error because it
reports all 289 dates which it cant display. Too many.

Any help will be appreciated

Scott V

 

[Duane Hookom]

I would create a small form with a text box to enter the date. Then set the
criteria in the crosstab to
Between Forms!frmDate!txtStartDate and Forms!frmDate!txtStartDate + 6

Select Query->Parameters and enter:
Forms!frmDate!txtStartDate Date/Time