I am attempting to create a database that will automatically schedule a group of employees and would like some help in pointing me in the right direction.
I would like to start off very basic and have a list of employees with the hours they can work and then have a list of shifts available. I would like to have the database assign employees to the available shifts if it fits within the hours they can work.
I'm just not sure how to start this. Can anyone give me some suggestions on where to start? Should this be done in a form, report, query? Again, i just need a starting point.
Thanks for any suggestions.
Paul
I would like to start off very basic and have a list of employees with the hours they can work and then have a list of shifts available. I would like to have the database assign employees to the available shifts if it fits within the hours they can work.
I'm just not sure how to start this. Can anyone give me some suggestions on where to start? Should this be done in a form, report, query? Again, i just need a starting point.
Thanks for any suggestions.
Paul