Auto populating a report (1 Viewer)

[anthonyphillips]

Hi guys

What I am looking to acheive is an auto populating rota system. By this I mean that Mr X works monday day tuesday night and wednesday day whilst Mrs X works monday night, tuesday day and wednesday night. Is there a way of setting the work patterns in the table and then populate a rota based on the working patterns.

Any ideas ?

thanks

Anthony

 

[Guus2005]

Don't know what a rota is but for the rest, yes, that is possible. You need to create a calendar for each and everyone.
It seems like a lot of work, but it is.

HTH

 

[anthonyphillips]

Sorry, a rota is a working or shift pattern sometimes called a rosta . . I assumed it was possible to set 7 fields titled Monday through Sunday, put yes or no in the fields against staff name and then where yes equals true then add name into report for working that shift.

Thanks
Anthony

 

[Guus2005]

You need to define all shifts for one day. This applies to all days.
If the employees can work 7 days a week, you can create a table which looks like this:

ROSTA
ID - identifies unique record. (autonumber)
EmployeeID - ID of employee
WeekNo - Number of the week
DayID - Number of the day in the week
ShiftID - Shift of the day

Use this table to set a duty roster for each employee.

HTH