I have asked about this a while ago, but I don't think I phrased it correctly.
We are trying to print out a group of pre-dated forms which will be filled out and returned to us by vendors. The vendor will lease a space from us for a period of time (say 05/01/03 to 12/31/03) of which we capture the StartDate and EndDate. There is some data for each deal which needs to be shown. I currently have the report complete, but it is just one page for each deal. Ideally, I would like to end up with a page for each week of the date range with the dates showing either as a header or as a line for each day. May 1st is a Thursday, so page one would be 05/01/03 - 05/04/03 (added bonus - weeks run from Monday to Sunday). Page 2 would be 05/05/03 to 05/11/03.
Desired result: All I select is which deal number to print, each deal has the fields Vendor Name, StartDate, and EndDate (among other things).
____________________________
(page 1)
05/01/03 - 05/04/03
Vendor Name, other vendor info
____________________________
(page 2)
05/05/03 - 05/11/03
Vendor Name, other vendor info
etc.
A date parameter was suggested, but I couldn't figure out how to group by the parameter field or automatically have it filled with the desired start and end dates. I also have already created a periods table with a record for each day from 01/01/03 to 12/31/12, which also can be used. I just can't figure out how.
Thanks for any help.
Jon
We are trying to print out a group of pre-dated forms which will be filled out and returned to us by vendors. The vendor will lease a space from us for a period of time (say 05/01/03 to 12/31/03) of which we capture the StartDate and EndDate. There is some data for each deal which needs to be shown. I currently have the report complete, but it is just one page for each deal. Ideally, I would like to end up with a page for each week of the date range with the dates showing either as a header or as a line for each day. May 1st is a Thursday, so page one would be 05/01/03 - 05/04/03 (added bonus - weeks run from Monday to Sunday). Page 2 would be 05/05/03 to 05/11/03.
Desired result: All I select is which deal number to print, each deal has the fields Vendor Name, StartDate, and EndDate (among other things).
____________________________
(page 1)
05/01/03 - 05/04/03
Vendor Name, other vendor info
____________________________
(page 2)
05/05/03 - 05/11/03
Vendor Name, other vendor info
etc.
A date parameter was suggested, but I couldn't figure out how to group by the parameter field or automatically have it filled with the desired start and end dates. I also have already created a periods table with a record for each day from 01/01/03 to 12/31/12, which also can be used. I just can't figure out how.
Thanks for any help.
Jon