Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-13-2019, 07:13 AM   #31
hatmak
Newly Registered User
 
Join Date: Jan 2015
Posts: 34
Thanks: 8
Thanked 0 Times in 0 Posts
hatmak is on a distinguished road
Re: calculate cumulative late

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
Attached Files
File Type: xlsx time.xlsx (9.3 KB, 4 views)

hatmak is offline   Reply With Quote
Old 08-13-2019, 07:19 PM   #32
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 7,600
Thanks: 59
Thanked 2,435 Times in 2,335 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: calculate cumulative late

check again.
Attached Files
File Type: zip Test_Time.zip (238.4 KB, 3 views)
__________________
"Never stop learning, because life never stops teaching"
arnelgp is online now   Reply With Quote
Old 08-13-2019, 11:50 PM   #33
hatmak
Newly Registered User
 
Join Date: Jan 2015
Posts: 34
Thanks: 8
Thanked 0 Times in 0 Posts
hatmak is on a distinguished road
Re: calculate cumulative late

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 is offline   Reply With Quote
Old 08-14-2019, 03:57 PM   #34
hatmak
Newly Registered User
 
Join Date: Jan 2015
Posts: 34
Thanks: 8
Thanked 0 Times in 0 Posts
hatmak is on a distinguished road
Re: calculate cumulative late




PLEASE HELP
hatmak is offline   Reply With Quote
Old 08-15-2019, 01:19 AM   #35
hatmak
Newly Registered User
 
Join Date: Jan 2015
Posts: 34
Thanks: 8
Thanked 0 Times in 0 Posts
hatmak is on a distinguished road
Re: calculate cumulative late

new file attached with more Explain in excel sheet to


please help
Attached Files
File Type: zip Files.zip (152.5 KB, 3 views)
hatmak is offline   Reply With Quote
Old 08-15-2019, 01:32 AM   #36
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 7,600
Thanks: 59
Thanked 2,435 Times in 2,335 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: calculate cumulative late

it would be easy if I just follow the format of your excel file.
easy to understand. is it ok for you?
__________________
"Never stop learning, because life never stops teaching"
arnelgp is online now   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
hatmak (08-16-2019)
Old 08-15-2019, 01:49 AM   #37
hatmak
Newly Registered User
 
Join Date: Jan 2015
Posts: 34
Thanks: 8
Thanked 0 Times in 0 Posts
hatmak is on a distinguished road
Re: calculate cumulative late

ok arnelgp

but note that all per employee


thank you for all your support


Last edited by hatmak; 08-15-2019 at 06:35 AM.
hatmak is offline   Reply With Quote
Old 08-15-2019, 03:49 AM   #38
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,025
Thanks: 40
Thanked 3,578 Times in 3,456 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: calculate cumulative late

crossposted here with answers https://www.accessforums.net/showthread.php?t=77950
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 08-15-2019, 03:59 AM   #39
hatmak
Newly Registered User
 
Join Date: Jan 2015
Posts: 34
Thanks: 8
Thanked 0 Times in 0 Posts
hatmak is on a distinguished road
Re: calculate cumulative late

CJ_London

no answer in mentioned post

still waiting for answer
hatmak is offline   Reply With Quote
Old 08-15-2019, 06:04 AM   #40
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 7,600
Thanks: 59
Thanked 2,435 Times in 2,335 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: calculate cumulative late

here is your form mr or ms? hatmak.
Attached Files
File Type: zip Files.zip (145.6 KB, 2 views)
__________________
"Never stop learning, because life never stops teaching"
arnelgp is online now   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
hatmak (08-16-2019)
Old 08-15-2019, 06:19 AM   #41
hatmak
Newly Registered User
 
Join Date: Jan 2015
Posts: 34
Thanks: 8
Thanked 0 Times in 0 Posts
hatmak is on a distinguished road
Re: calculate cumulative late

Hatmak is Mr.

after I changed time for morning for employee 08:00 ( start time ) and 15:30 ( end time ) in data DATA_QRY


percenatge deducated Not changed still 10 % and other

attached file after change time in and out
Attached Files
File Type: zip Files_1.zip (183.3 KB, 1 views)
hatmak is offline   Reply With Quote
Old 08-15-2019, 06:46 AM   #42
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 7,600
Thanks: 59
Thanked 2,435 Times in 2,335 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: calculate cumulative late

test it again mr.
I saw your post on the other side of the world.
only chit chat, no action.
Attached Files
File Type: zip Files.zip (126.0 KB, 3 views)
__________________
"Never stop learning, because life never stops teaching"
arnelgp is online now   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
hatmak (08-16-2019)
Old 08-15-2019, 06:56 AM   #43
hatmak
Newly Registered User
 
Join Date: Jan 2015
Posts: 34
Thanks: 8
Thanked 0 Times in 0 Posts
hatmak is on a distinguished road
Re: calculate cumulative late

I posted my post in all the world to any advise

but no one response

really you patient and Creator

thanks you a lots for your response

please check attached file
is 66 min delay but percentage still 10 %
Attached Images
File Type: png 11.png (43.5 KB, 2 views)
hatmak is offline   Reply With Quote
Old 08-15-2019, 07:51 AM   #44
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 7,600
Thanks: 59
Thanked 2,435 Times in 2,335 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: calculate cumulative late

mr. hatmak, one more test see what is wrong.
Attached Files
File Type: zip Files.zip (138.3 KB, 5 views)
__________________
"Never stop learning, because life never stops teaching"
arnelgp is online now   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
hatmak (08-16-2019)
Old 08-16-2019, 08:38 PM   #45
hatmak
Newly Registered User
 
Join Date: Jan 2015
Posts: 34
Thanks: 8
Thanked 0 Times in 0 Posts
hatmak is on a distinguished road
Re: calculate cumulative late

thank you Mr. Arnelgp

some trouble last days made me can't open internet

I will test and tell you

thanks


Last edited by hatmak; 08-16-2019 at 08:45 PM.
hatmak is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access to calculate cumulative sum in Query - DSUM performance very slow Icecream Queries 2 11-16-2015 03:30 AM
Calculate quarterly figures from cumulative data scubadiver007 Modules & VBA 27 11-09-2011 08:03 AM
Need to calculate difference from cumulative data scubadiver007 Queries 12 07-18-2011 07:29 AM
Question Best way to Calculate Late Fees PNGBill General 0 06-13-2010 04:14 PM
How to calculate cumulative values of this query fields? tony007 Queries 5 07-13-2005 06:46 AM




All times are GMT -8. The time now is 03:09 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World