Report for each day within a range

[jason_nevin]

I've developed a query that uses a date from a control to produce a report headed with that date. I'd like to modify this so that I can enter two dates and produce a report headed with each date within that range or alternatively run the report for each date within the range. Is this possible?

 

[neileg]

Use the Between operator to use the two dates you input as criteria in your query. Use sorting and grouping within your report spec to group by day.

 

[jason_nevin]

I think you've misunderstood. I'm supplying the date range as a parameter i.e 01/05/2004 - 04/05/2004. For each date within that range I need to run a distinct query headed by the supplied date. If I use 'between' I'll get one query with all of the data for this period. I can't group by a date because there isn't one in my data.

 

[neileg]

I think you've misunderstood. I'm supplying the date range as a parameter i.e 01/05/2004 - 04/05/2004.

Nope, I understood.

For each date within that range I need to run a distinct query headed by the supplied date.

Why? You said you wanted separation in the report. That doesn't depend on separate queries.

If I use 'between' I'll get one query with all of the data for this period. I can't group by a date because there isn't one in my data.

You are testing for a date so the date must be there in the query. If you are not returning the date value, then change that. The fact that the date is part of the dataset does not mean you have to show it in the detail of your report, but you will need it as a header in your report anyway, since you want to show the data by date.