calculate cumulative late

[arnelgp]

hatmak, what is the starting Time and the Ending time of work?
I will try to complete your requirement.

 

[hatmak]

Thanks arnelgp

Start time 08:00
End time 15:30

Thsnks for your help

 

[arnelgp]

here is your attenance form.
i added the following:

form: attendance_form

tables: attendance_tb
delay_tb
months_tbl

you open attendance_form.

 

[hatmak]

thanks arnelgp for your help

but my design db.

any employee have 240 min. in month for morning late or departure early ( permission )

this permission in minutes in morning

i he come 08 : 30 his take 30 min. from 240 min
second day 08 :15 take 15 min.

and after 240 min.
i dedicate as i told you before

and i calculate this time to set his deduction on salary

in new design how to set this

or can you make it as my desgin db

regards

 

[hatmak]

arnelgp

when i attached excel sheet

i attached it for make the same formula

 

[arnelgp]

again, plz.
so employees has allowance of 240 minutes in a month.
if he exceed this (cumulative) from his/her lates, then that's the time we will compute the minute delay?

 

[hatmak]

exactly arnelgp

when employee exceed 240 min morning and departure

 

[arnelgp]

ok, let me take time. ill think about it tomorrow.

 

[hatmak]

thanks arnelgp

 

[arnelgp]

check if this is correct?
if not post an excel with sample (not the one you post previously) that my small brain can understand.

 

[hatmak]

in query DATA_QRY

i had two field CummulativeLate (min): Val(Nz(fnCummulativeLate([id],[uotono]),0))


and

cummulativeealy(min): Val(Nz(fnCummulativeealy([id],[uotono]),0))

and this fields as you know are cumulative per employee

i need new filed with name percentage deducted

this field with formula as attached excel

regards

 

[arnelgp]

check again.

 

[hatmak]

I try to change data and time

no time change and parentage

can do this equation in query DATA_QRY

to be easy to me

employee in company more than 500

I appreciated your support

 

[hatmak]

PLEASE HELP

 

[hatmak]

new file attached with more Explain in excel sheet to


please help

 

[arnelgp]

it would be easy if I just follow the format of your excel file.
easy to understand. is it ok for you?

 

[hatmak]

ok arnelgp

but note that all per employee


thank you for all your support

 

[CJ_London]

crossposted here with answers https://www.accessforums.net/showthread.php?t=77950

 

[hatmak]

CJ_London

no answer in mentioned post

still waiting for answer

 

[arnelgp]

here is your form mr or ms? hatmak.