calculate cumulative late (1 Viewer)

arnelgp · Aug 12, 2019

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

hatmak · Aug 12, 2019

Thanks arnelgp

Start time 08:00
End time 15:30

Thsnks for your help

arnelgp · Aug 12, 2019

here is your attenance form.
i added the following:

form: attendance_form

tables: attendance_tb
delay_tb
months_tbl

you open attendance_form.

hatmak · Aug 12, 2019

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 · Aug 12, 2019

arnelgp

when i attached excel sheet

i attached it for make the same formula

arnelgp · Aug 12, 2019

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 · Aug 12, 2019

exactly arnelgp

when employee exceed 240 min morning and departure

arnelgp · Aug 12, 2019

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

hatmak · Aug 12, 2019

thanks arnelgp

arnelgp · Aug 13, 2019

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 · Aug 13, 2019

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 · Aug 14, 2019

check again.

hatmak · Aug 14, 2019

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 · Aug 15, 2019

PLEASE HELP

hatmak · Aug 15, 2019

new file attached with more Explain in excel sheet to

please help

arnelgp · Aug 15, 2019

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

hatmak · Aug 15, 2019

ok arnelgp

but note that all per employee

thank you for all your support

CJ_London · Aug 15, 2019

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

hatmak · Aug 15, 2019

CJ_London

no answer in mentioned post

still waiting for answer

arnelgp · Aug 15, 2019

here is your form mr or ms? hatmak.

calculate cumulative late (1 Viewer)

..forever waiting... waiting for jellybean!

Registered User.

..forever waiting... waiting for jellybean!

Attachments

Registered User.

Registered User.

..forever waiting... waiting for jellybean!

Registered User.

..forever waiting... waiting for jellybean!

Registered User.

..forever waiting... waiting for jellybean!

Attachments

Registered User.

Attachments

..forever waiting... waiting for jellybean!

Attachments

Registered User.

Registered User.

Registered User.

Attachments

..forever waiting... waiting for jellybean!

Registered User.

Super Moderator

Registered User.

..forever waiting... waiting for jellybean!

Attachments

Similar threads

Users who are viewing this thread