Calendar Report

[Rocky]

Hi

I have looked at all of the posts on this subject and downloaded Duane
Hookom's demo. Most of the discussions centre around single date
entries.

My databse has three fields, "Event";'Start_Date" and "End_Date. If I
use Duane's demo, how do I programatically make entries for each of
the dates in the range. For example, if my entry is as follows:-

House & Garden Show; 15 July 2007; 20 July 2007.
How do I programatically make a table that shows each date entry as
follows:-
House & Garden Show;15 July 2007
House & Garden Show;16 July 2007
House & Garden Show;17 July 2007
House & Garden Show;18 July 2007
House & Garden Show;19 July 2007
House & Garden Show;20 July 2007

Thanks
Rocky

 

[Duane Hookom]

Create a table of all possible dates with a single date field.
tblDates
==========
TheDate date/time

You can then add this to your subreport's record source without any join
lines. Set the criteria under the [TheDate] field to:
Between [Start_Date] AND [End_Date]
This should create one record for each date of the schedule.