Need help creating a calendar report

[Guest]

I am trying to create a task list calendar... I have a Publish date and want
to dynamically create a list of tasks leading up to that date.

For example:

Sample product is due to publish on August 15th 2005 I want to dynamically
create several task corresponding to Sample Product. the tasks are as follows

August 15th - Publish Date
July 22nd - Finish Product (24 days prior to publish
date)
July 19th - Final Submission Deadline (27 days prior)
July 14th - Final Contact (32 days prior)
July 7th - Second Contact (39 days prior)
June 30th - First Contact (46 days prior)

So the trick is that I have 115 items with publishing dates that spread
across the entire year...

As I said before, I want to be able to create a calendar using the publish
dates that correspond to the items...

I appreciate any input regarding this!

 

[Steve]

Contact me at (e-mail address removed) and I will send you a screen shot of what I
have.

Steve

 

[Duane Hookom]

There are sample calendar reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. Do you also need to
create the schedule dates?

 

[Guest]

Just a note of clarity... The primary function I am looking for is the
ability to dynamically generate the dates that correspond to the publish date
so that I don't have to manually enter the corresponding dates. I am
possiably willing to store the generated dates on a table, however I am
trying to prevent that as well... The idea is to enter a publish date and use
a formula to generate the other dates and pop that data onto a calendar.

 

[Duane Hookom]

Do you have a table of each task and the prior to dates? If so, you can
query your publish date table with the task table without a join. Add the
Publish date to the days prior number field to get a list of all tasks and
dates. You can use this recordset as the source for a report.

 

[Guest]

Thanks! I decided to create a calendar table so that I have easy access to
the calendar info... I used your idea and created vba that requeries the
tblcalendar every time i want to create a calendar...

Now, I am trying to modify the sample code you have, however your control
seem much more complex than what I need... I don't mind a fixed "month" style
calendar... also, all of my dates fall within the m-f workweek.

Will I need to create a seperate query for each day of the week the way you
do? or is there a better way to do it?

Thanks for your feedback!

 

[Duane Hookom]

I can't see/read any of the previous messages in this thread and I am too
old to remember. Consider starting a new thread with a complete description
of your current tables and requirements.