calculate cumulative late (1 Viewer)

hatmak

Registered User.
Local time
Today, 07:01
Joined
Jan 17, 2015
Messages
121
How to calculate cumulative late per employee during month
Query DATA_QRY
Filed name Cumltive_Late
 

Attachments

  • Test_Time.mdb
    900 KB · Views: 181

isladogs

MVP / VIP
Local time
Today, 14:01
Joined
Jan 14, 2017
Messages
18,186
Answering on my phone so haven’t looked at your database

Create an aggregate query by clicking the Totals button on the ribbon. Add the employee, date and late fields to the query. All wii day Group By in the Totals row.
Now change the date field to Month(Your Dare Field). Also change the Group By to Sum for your late field.


Sent from my iPhone using Tapatalk
 

hatmak

Registered User.
Local time
Today, 07:01
Joined
Jan 17, 2015
Messages
121
please look to database
 

isladogs

MVP / VIP
Local time
Today, 14:01
Joined
Jan 14, 2017
Messages
18,186
Its not easy for me to understand the fields as I can't read Arabic(?)
This is roughly what I described before. Adapt as necessary

Code:
SELECT Sum(DATA_QRY.S) AS TotalLates, DATA_QRY.Payroll_No, DATA_QRY.Name, Month([Date_late]) AS [Month]
FROM DATA_QRY
GROUP BY DATA_QRY.Payroll_No, DATA_QRY.Name, Month([Date_late]);
 

hatmak

Registered User.
Local time
Today, 07:01
Joined
Jan 17, 2015
Messages
121
new database English filed

cumulative late per employee during month
Query DATA_QRY
Filed name Cumltive_Late


as attached in DATA_QRY

Cumltive_Late
 

Attachments

  • Test_Time.mdb
    1.3 MB · Views: 152

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 22:01
Joined
May 7, 2009
Messages
19,169
hello there, lucky I am here to help you.
 

Attachments

  • Test_Time.zip
    168.1 KB · Views: 163

hatmak

Registered User.
Local time
Today, 07:01
Joined
Jan 17, 2015
Messages
121
yes I'm very luck :)

many thanks arnelgp:):):)
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 22:01
Joined
May 7, 2009
Messages
19,169
youre welcome!
 

hatmak

Registered User.
Local time
Today, 07:01
Joined
Jan 17, 2015
Messages
121
can u make it with number of minutes

format number not time
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 22:01
Joined
May 7, 2009
Messages
19,169
do you mean "whole number" in minutes only.
example:
1 hr 20 minutes = 80 minutes (this 80, you need?)
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 22:01
Joined
May 7, 2009
Messages
19,169
here is your db. there are no accumulated hours, only in minutes.
 

Attachments

  • Test_Time.zip
    136.6 KB · Views: 164

hatmak

Registered User.
Local time
Today, 07:01
Joined
Jan 17, 2015
Messages
121
can you help in DepatureDel


I can't do it
 

hatmak

Registered User.
Local time
Today, 07:01
Joined
Jan 17, 2015
Messages
121
after I make

Cumltive_Late

Cumltive_out



Can I do this

1 hour late ---- (round up to 1 hour) 10 % ( per day )

2 hour late ----(round up to 2 hour) 30 %

cumulative total 40 %

3 hour late ----(round up to 3 hour) 45 %

cumulative total 85 %

4 hour late ----(round up to 4 hour) 60 %

cumulative total 145 %

5 hour late ----(round up to 5 hour) 75 %

cumulative total 220 %

6 hour late ----(round up to 6 hour) 90 %

cumulative total 310 %

7 hour late ----(round up to 7 hour) 100 %

cumulative total 410 %


and should be in end month 100 % not more


 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 22:01
Joined
May 7, 2009
Messages
19,169
post the db you have so far.
 

hatmak

Registered User.
Local time
Today, 07:01
Joined
Jan 17, 2015
Messages
121
attached excel example
 

Attachments

  • attendance.xlsx
    15.7 KB · Views: 175
  • Test_Time.accdb
    880 KB · Views: 164

Users who are viewing this thread

Top Bottom