Question DSum Problem Between 2 dates

Badeye

Registered User.
Local time
Today, 04:28
Joined
Oct 14, 2011
Messages
22
Hi Guys,

So i'm in the middle of a project but have found myself against a brick wall.

My project is to build an employee holiday calculator. I have alot of of it already working but the bit i am stuck at is this:

Employees in the holiday calculator have their holidays calculated as below
Contracted Staff = Contracted hours x 4 (GB & NI)
Contracted Staff = Contracted hours x 3.454 (IOM)

If an employee is a casual worker their holiday entitlement is based on the number of hours they have worked as they would have 0 contracted hours as below

Casual Worker = total number of hours worked x 0.1207

If an employee works in ROI then no matter what contracted hours they have they too have their entitlement based on the total hours worked as below:

ROI Worker = total number of hours worked x 0.08

Hope this makes sense so far....

In my Employees table there is fields allocated for change in contracted hours these are

Cont_hrs2, Calc2, Start_Date2
Cont_hrs3, Calc3, Start_Date3
Cont_hrs4, Calc4, Start_Date4
Cont_hrs5, Calc5, Start_Date5

On my form i have 5 textboxes that display accrual1, accrual2, accrual3, accrual4 and accrual5. The entitlement in each of these boxes would show what the employee has accrued between each amendment date. I then have a text box that adds all the accruals together and is called total accrual.

The problem i am having is, i have a table called hours worked for the casual and ROI staff and i want to pull out the total hours the employee has worked between the amendment dates. Hope this makes sense.

My project is just over the max file attachment limit for here so i will be more than happy to email it to anyone that is willing to help.

BTW i am very new to this so am still learning.

Thanks,

Si
 

Users who are viewing this thread

Back
Top Bottom