Vo0do0uk said:
Sorry Parker - i keep getting confused
The time worked is the information from calculating the rosta. to change the time worked i would need to change the rosta. so these will have the same information
-- why would i need to record the same information twice?
NO NO NO NO NO !
Time worked is time worked
Time schedule is time shedule.
If I tell one of my staff there working for 16hrs on Next Sunday they may agree(not if the've got any sense) but they may phone in sick on Saturday.
What are you going to do then? Print a new rosta so everyone knows in time?
If the guy attends then use a riutine to say that he completed the shift. If he dosn't attend then, chances are someone else will fill in, so you just record their times instead. If he does attend but doesn't complete the shift then you just need to ammend his finish time.
Rosta is a calculation ------- don't store calculations.
Time worked is information and needs to be stored.
Once again you have two issues (pos 3 if you want to be clever)
- Schedule
- time worked (for wages and IRS calc)
- (pos)availability
Idealy you would check availability then work out the rosta and then store the time worked for wage calculations.
If you store availability you can use this in a query to work out the rosta. Then print the rosta using a report (as in my examples) sometime latewr you would enter the actual times (into a form bound to a table) worked and use this with queries to work out wages, etc.