Duty Allocation

[rajeevs]

Hi All
I am in the process of developing a database and part of that i need to generate a roster for the staff duty allocation.
The duties are morning afternoon and night and the duty pattern with equally 8 hours.
There will be say 7 to 8 persons in a crew and five or six work positions. What i need to do is a pattern to allocate each person equal amount of time on a rotation basis to different positions and equal amount of break times.
From a form i can have a drop down list of the duties. Once the duties, number of persons ( like an input to a textbox) and the time range selected i need to generate a roster. Hope my question is clear and appreciate anyone could help me on this issue.

Thank u all for the support i always get from bytes

[NeoPa]

What data structure would you be working to here?

[rajeevs]

Hi Neo

I dont want to store anything in the table. My request is to generate a duty pattern everyday for the staff when the supervisor click a button on the form
it should be like
as an example
Duty
Morning
staff1 work on pos1 time between 0230 to 0330, break for say 45min then pos3 for 1hr 30 min then break for 30 min.
if total staff available 7 they all need to work on positions like pos1 pos2 etc and need to get break after every position duty like that.
Duty hours always 8 hrs for selected duty ie, morning afternoon and night
Only the staff count varies sometimes 7 or 8. But the position are pre defined like pos1 to pos 5 or 6
I am struck with this because i am not sure how to define the tables, and how many tables required etc.
the end user ( ie. the supervisor of the shift) will have to click a button from a form after selecting the duty (ie, morning afternoon or night) and number of persons available for that duty and then he should get a report which shows an equally distrubuted time for each person on the positions and equal break time
Hope you understand what is my requirement and waiting for a favourable reply
Thank you for the prompt reply

[NeoPa]

I can't understand what the question is. I thought the table layout would give me a clue, but you tell me there are no tables, then you tell me you don't know what the tables are.

It also sounds like you want the form to do the allocation for you, rather than show you what is there, so you can do that yourself (as the operator).

I see no evidence of your even having started on this so I'm not sure what sort of help you're expecting. I can certainly say that I am not prepared to just do it for you. I will happily answer any questions I can that will help you do it, but I don't even understand the question as there's so little information here.

[ChipR]

This is a programming problem that needs to be solved before you think about implementing it in Access. You need at least a strategy describing the rules of how you want to assign shifts pogrammatically .

[Stewart Ross]

Rajeevs, please read our posting guidelines before you post again in this forum, and in particular please read the FAQ about posting homework questions. I reckon your current post, like several of your previous posts, relates to coursework or homework of some kind. I will be in touch with you by Private Message on this topic.

MODERATOR

[rajeevs]

Hi All
I apologize if my question was not clear.
I didnt mean that i have no tables for this duty allocation. I create a table TblDuty with fields as Date, Duty, Staff, Position, TimeOn, TimeOff. The form is designed with unbound controls like TextBox Date(), Combobox for Duty (value list as Morning, Afternoon Night), TextBox to enter number of staff. My request is for a script or query which can allocate the duty and view in a report. The data generated can be saved to TblDuty for future reference. Thank for the help

[Stewart Ross]

Sorry Rajeev, this is one of those occasions when we cannot assist. We do not know the details of your application, nor can we provide you with code for such a specific requirement when there is not the slightest indication that you have made an attempt to design a scheduling algorithm for yourself.

NeoPa and Chip have already said as much to you in their replies.

Designing a scheduling algorithm is not a trivial task, and even if you did provide enough detail about the task we cannot act as unpaid consultants for the design of your application.

The volunteer staff of this site try to help users with specific tasks, users who have already put effort and time into their development and need to slot a particular part of the puzzle into place before they can move onwards.

What our volunteers cannot do is to design your application for you - no matter how many unbound controls you already have on your form.

I will not close this thread yet, to allow you some time to reconsider your request.

MODERATOR