Question Workforce schedule help.

[jigax]

Hello everyone,

I would like some assistance in accomplishing the following.

I have a table with the following fields employees and the days of the week. I want to create a simple application that will generate a 5 day schedule for each of these employees, however I need to have everyone work Mon,Fri and Sat and 30% of the employees on sunday.

Thanks in advance.

 

[cjard]

As it stands, your post is not enough of a spec to allow us to help you. Please add more words to it

 

[jigax]

Basically I have a table with the following fields. Employee ID (int), Monday(checkbox), Tuesday(checkbox), Wednesday(checkbox), Thursday(checkbox), Saturday(checkbox) and Sunday(checkbox). I want all of the employees to work Monday, Friday and Saturday therefor these checkboxes should be checked for all employees. I only want employees to work 5 days a week. However on Sunday only 30% of employees could work, no less no greater. I hope this makes sense. If you have further questions please ask.

Thank you