Creating work schedule in Excel based on criteria

[Shanthan]

Hi,

Is it possible to automatically create a workplace schedule on Access based on some pre-defined criteria? E.g.,



There are 3 departments (A, B and C) and about 40 employees. Some employees can work in department A and C, some in department A and B and some in department B and C, etc.
There are full-time employees (10 shifts per pay period), part-time employees (5-10 shifts per pay period) and casual employees (2-5 shifts per pay period)
If full-time employees work on the weekend, they will get Monday and Tuesday off.

Does anyone have any suggestion on how I can approach this? Can someone show me a demo?

Thanks

[June7]

I am sure is possible but will require a bunch of VBA code.

I Googled: Access work schedule database

Got several hits. See if these give you some ideas:

http://www.ehow.com/how_12009146_mak...ft-access.html

http://softwaretopic.informer.com/wo...tabase-access/

https://www.accessforums.net/databas...ses-18459.html

[Shanthan]

Thanks for your reply. I have attached a template of the schedule. The two columns on the right will hold the employee names and the cells beside each name will hold the shift they'll be working that day. I need to be able to generate the shifts so that I can fill in those cells.

[June7]

I said I expect it can be done, not that I could or would. That's not what this forum is for. What you want would be a very involved and time-intensive effort. I have provided references for you to learn from and attempt application to your situation. When you encounter specific issues in your development effort, post questions and hopefully someone will have answers.

[Shanthan]

This is the first time I will be working with Access. As you can imagine, it's going to take a very long time for me to get this done, which is why I wanted to make sure that it is possible to do exactly what I needed before I even get started. I wasn't expecting you to actually do it for me. I will certaintly come back and ask questions if I get stuck on something. Thanks for the tips.