Scheduling Database - Needs Calendar

[James]

I am creating a scheduling database. I think I have to have a table with all
of the dates from 2005 to 2015 (The table can be updated to add more dates
after that). The reason for the dates table is so there is a record created
for each date. I don't want the user to have to create a new record each
time (but that might have to happen). I am planning on having a grid based
form. It will show 7 columns (1 column is one day), and the rows will be
the fields from the positions (job title) table.

My question: Do I need to create a table that has hundreds of records (one
record for each date for 10 years)? If yes, how do you do create a dates
table (I guess I can use excel and auto fill the dates? Is there a bettter
way to accomplish this?

 

[Duane Hookom]

I would make sure your table structure is normalized. There is a sample mdb
on how to schedule recurring events at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane and
calendar reports at http://www.invisibleinc.com/divFiles.cfm?divDivID=4.