I have a report that's basically a calendar. I need to get a footer
that shows the range of dates on the current page (a start date and end
date). I know how to do that by putting a field in the header and using
some VB code to assign footer values.
What I don't know is how to show the start date on the second and
subsequent pages to reflect the previous page's end date. The dates are
based on a record's date field, so every day of the month is not
accounted for.
--------------------------------------
Example of what I currently have:
(Page 1)
1/1/04 to 2/15/04
(Page 2)
2/20/04 to 2/25/04
(Page 3)
3/2/04 to 4/1/04
--------------------------------------
Example of what I want:
(Page 1)
1/1/04 to 2/15/04
(page 2)
2/15/04 to 2/25/04
(page 3)
2/25/04 to 4/1/04
-------------------------------------
So, the problem is getting page 2 and 3 to start at the previous page's
end date. Any suggestions?