scheduling database

[eb1mom]

I am preparing to make a scheduling database for employes
who work 5 eight hour shifts a week. One shift per week is
not staffed. Are there any access demo databases close to
this? Thanks

 

[Duane Hookom]

Close to what? You haven't really provided any requirements or
specifications.

 

[eb1mom]

Sorry,was pretty skimpy didn't want to get too long winded.
Three tables.
CrewTable, Fields, CrewId-CrewName
ShiftTable, Fields, ShiftID-ShiftName-StartTime-StopTime
ScheduledTable, Fields, CrewId-ShiftId-DateScheduledToWork.
I was trying for a calendar form to pick date with a
subform to pick 3 shifts and 3 crews to work. One record
would be Datescheduled-ACrew-NightShift Thanks

 

[Duane Hookom]

There is a small sample database "recurring.mdb" that you might want to look
at from http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[eb1mom]

Thanks Duane, That database answers many questions.