calculate cumulative late (1 Viewer)

hatmak

Registered User
Joined
Jan 17, 2015
Messages
45
How to calculate cumulative late per employee during month
Query DATA_QRY
Filed name Cumltive_Late
 

Attachments

isladogs

CID Moderator
Staff member
Joined
Jan 14, 2017
Messages
12,349
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
Joined
Jan 17, 2015
Messages
45
please look to database
 

isladogs

CID Moderator
Staff member
Joined
Jan 14, 2017
Messages
12,349
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
Joined
Jan 17, 2015
Messages
45
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

hatmak

Registered User
Joined
Jan 17, 2015
Messages
45
can u make it with number of minutes

format number not time
 

arnelgp

error reading drive A:
Joined
May 7, 2009
Messages
8,632
do you mean "whole number" in minutes only.
example:
1 hr 20 minutes = 80 minutes (this 80, you need?)
 

hatmak

Registered User
Joined
Jan 17, 2015
Messages
45
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


 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom