Employee Shift Schedules

[Melissa]

HI there

I am creating a db for a security company. I have a form for "Clients", a
subform for "Contracts", and also and "Employee Form".

I would like to find a way to keep track of the shifts that the employee
works. Each Client has 2 -4 day shift security gaurds (employees), and 2-4
Night shift gaurds.

How can I record which employees worked on which days/shifts? I would also
need to be able to print reports with this info at a later stage.

Please could someone assist me

Thank you kindly
Melissa

 

[Tom van Stiphout]

On Fri, 6 Feb 2009 09:04:17 +0200, "Melissa" <[email protected]>
wrote:

We did this for a client. You need to make distinction between a job
occurrence which is a client saying "today I need 3 guards from 6am to
9pm" and the many guards it takes to cover that time period. Each
guard has his/her own startDateTime and endDateTime. Depending how
cool you want the UI to be you could show a graph with the periods
where you already have sufficient coverage, and the periods for which
you need to continue recruiting.

-Tom.
Microsoft Access MVP

 

[Melissa]

Hi Tom

Thank u very much for your reply.

so basically what I need to do would be to put text boxes on the "Employee"
form for StartdateTime and endDateTime. Then also, how would I choose which
client the employee is working at? Eg, "Simon" could work at ACB Trading
today, but next week he works somewhere else?

Thank you kindly,

Melissa