WorkForce Scheduling......

[weilerdo]

HI All....

I have a question which I believe I may already know the answer to but Here it goes. I am trying to create a db that can track and employee shift schedules. I have 28 employees and we work 24X7 so we have 3 shifts, days, evenings and night. I cant seem to get my head around how I would create it. I have tried like 10 different ways but I keep running into Form limits. They want to be able to schedule for the whole year out by month. I have attached a sample of what they want it to look like. If anyone knows of anything out there or could assist me in at least a correct starting point, I would be forever in debt to you.

Thank you for taking the time to read this post and I look forward to hearing from you.

 

[The_Doc_Man]

Search this forum for topics including the word "Schedules" and "Shift" - the topic has been addressed many times.

 

[weilerdo]

RE: WorkForce Scheduling

I have searched all of the 287 post on this and have not found anything that is like what I am looking at. I have also searched for 2 days on google to no avail.

 

[The_Doc_Man]

I think your problem is that you are treating forms like Excel Spreadsheets. They are not. You are using spreadsheet thinking on a relational database. You are going to have a lot of trouble as long as you do that.

I hate to be negative towards Access but this is a case where you MIGHT want to stay in Excel. But if that is not what you want, I advise you to go back and re-read those 287 matching posts. I guarantee you in writing signed in gold-leaf ink that this topic has been discussed before. Don't limit yourself too narrowly when looking at the topic titles. Sometimes what you really wanted to see is in the body of the thread.