Payslip to Detect Holiday Automatically

[jmq]

I have this problem that i can never ever figure it out how to start.

table_Holidays:
1. ID
2. Date
3. Holiday Type
4. Holiday Discription

table_Timesheets:
1. ID
2. Employee.ID (linked to table_Employees)
3. Work Date (to hold -when)
4. Hours Worked (to hold -how many hours worked on work date)


Now when i input the date that i have set to be holiday, i want it to be double pay. :banghead:

How do you do that?

 

[arnelgp]

You do the calculation like:

Pay= ([hrs work] *[hour rate]) + ([hrs work] *[hour rate]*dcount("*", "table_holiday", "[date] =#" & format([work dare], "mm /dd/yyyy") & "#")

 

[Mark_]

To save a lot of headaches down the road, I'd include a "Rate" in your "Table_Holidays", just so that when the company decides a specific holiday is paid at a rate other than double time you won't have much work to do.

You would then also be able to use DLookup to return the rate for the holiday in question.

 

[jmq]

@arnelgp: with this technique, i should be inputting the time sheet in a daily basis. to determine the date. not just the mon, tue, wed .. technique. right?

 

[jmq]

@Mark_: Thanks mark! that would be very helpful!

 

[jmq]

@Uncle Gizmo: Just now. i'll have a peek. Thank you!

 

[arnelgp]

Yrs daily basis, dont forget to input the ot hrs also.

 

[jmq]

@arnelgp: I am not required to do it in a daily basis. we were given a 15day-DTR already consolidated. i just have to input how many hours did the employee worked for 15 days, how many OT and holidays. i guess to automatically detect the holiday would not be applicable for this. right? i have finished my employee record. now i'm building the next form for the consolidated DTR. in 1 month we generate 2 payrolls.

 

[arnelgp]

Whether one time or daily dowsnt matter, what i gave is just a general formula.

 

[jmq]

@arnelgp: yeah right.. Thanks!

 

[jmq]

You do the calculation like:

Pay= ([hrs work] *[hour rate]) + ([hrs work] *[hour rate]*dcount("*", "table_holiday", "[date] =#" & format([work dare], "mm /dd/yyyy") & "#")

how does dcount work?