Dynamic dates in a Report Header 1

[erich13us]

I have a report based on a crosstab query. The crosstab query in turn is based on a query that allows me to set a start and end date. I want the start and end dates in the header of my report. How do I get it there?
Erich

 

[geaker]

Erich,
Does the first query write the data to a table that the crosstab query is using. I had a similiar problem and just wrote the start and end dates to the table when the first query is ran. Then you can use the dates as row heading and include in your report.

Gerald

 

[erich13us]

The first query is an ordinary select query

 

[erich13us]

The question would be how do I write the start and end date to the new table and will I get a date for each row of data?

 

[geaker]

Erich,
The SQL would be:
Enter the Start Date You Want] AS ReportDate, [Enter the End Date You Want] AS EndDate

This prompt the user to enter the date and also would include the dates in the table you create from your first make table query. Then you would use that table for the crosstab quesry and yes you would get the dates on each line but you could pick and choose what to include when you build the string that contains the customer information.

Gerald