calculate cumulative late
- Thread starter hatmak
- Start date
isladogs
MVP / VIP
- Local time
- Today, 00:16
- Joined
- Jan 14, 2017
- Messages
- 18,549
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
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
isladogs
MVP / VIP
- Local time
- Today, 00:16
- Joined
- Jan 14, 2017
- Messages
- 18,549
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
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]);
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
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
