Recent content by linkaccess

I'll control the date range to include the current date + 30 days. The user should be able to scroll across the available dates.

I have a table that lists employees, the date and their daily status. tblEmployeeDailyStatus DailStatusID (PK) DailyStatusDate Employee DailyStatusCode (DSC) I would like to create a form that lists the schedule in this format. 01/01/2013 01/02/2013 01/03/2013 01/04/2013 01/05/2013 etc...

Thanks for the help! I was just thinking (making this harder for myself). What if I set up a table like this: DayOffRotationID (PK) DayOffRotationName Sunday1 - yes/no Monday1 - yes/no Tuesday1 - yes/no and continue the days until it would end Friday4 - yes/no Saturday4 - yes/no yes/no would...

I'm somewhat comfortable with it.

Your example is just what i have. I just can't figure out the best way to set it up.

I'm setting up a scheduling database and need help in setting days off. A record is generated for each employee [employeetableID] for the entire year. The record contains their shift assignment [shifttableID], day off rotation [dayofftableID] work status [statustableID-Working, Off, Training...