Payroll calculations

[Rogue]

Hi there!



Sorry, I'm not sure if this query has been raise before. I was trying to workout my dbase and its making me sick now, hope someone could help me

I have attached here my dbase and following are my concerns:

1. Summary to display attendance/OT hrsfor specific period (e.g. jun16 to july 15) for individual employee and other for all like below heading:

No.

Emp. ID

department

DESIGNATION

Starting Date

End Date

No.of Days Work

REMARKS

1

123

office

accountant

16/06

15/07

31

REMARKS

2. If possible to remove the table for date and time but still be able to have a dropdown list to choose from, whenever I encode staff daily attendance and to retain attendance history.
Our regular hours is 9.5 daily any excess to this is considered OT and there is no fix timings that's why there is 3 timeIn and 3 timeOUt.
3. To calculate OT pay on the following basis : total salary/30days/9hrs*OTHrs

I will really appreciate if anyone can help me on this.

Thanks,

Rogue

[rzw0wr]

Don't see an attachment.
Dale

[rzw0wr]

1. Summary to display attendance/OT hrsfor specific period (e.g. jun16 to july 15) for individual employee and other for all like below heading:

No.

Emp. ID

department

DESIGNATION

Starting Date

End Date

No.of Days Work

REMARKS

1

123

office

accountant

16/06

15/07

31

REMARKS

What form name.
Explain further what it is you want to do.
Just the first problem for now.
Dale

[Rogue]

Sir Dale, thank you for your time... I plan to make new form for number 1....

[rzw0wr]

Then there is not a problem number 1 anymore?
If that is true then explain fully what you want to do for problem 2.

Dale

[Rogue]

Hi sir, sorry for late reply just now I see your succeeding post...For requirement #2, it is somewhat related with #1. Currently when I am to input daily attendance I still need to add the date like for next cut off (july 16 to aug 15) is not yet in the date table, so I what to remove it. Instead, I would like to have a calendar like, wherein I can choose date and time the employee is present.But still be able to keep it in history that I can go back whenever I would like to view the attendance for a specify period.

2. If possible to remove the table for date and time but still be able to have a dropdown list to choose from, whenever I encode staff daily attendance and to retain attendance history.
Our regular hours is 9.5 daily any excess to this is considered OT and there is no fix timings that's why there is 3 timeIn and