cumulative Percentage equation

[hatmal]

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


file attached again

[hatmal]

PLEASE HELP

[June7]

Had to remove all the (Arabic?) captions from tables so i could understand tables and queries. I never set captions in tables.

Name and Month are reserved words - should not use reserved words as names for anything.

Your calculation requirements are not clear to me. Why does 8 min late and 7 min early result in 75% deduction?

Why do you add late and early minutes?

[ssanfu]

Also be aware of:

"Time" is also a reserved word.

Code module does not have "Option Explicit" at the top.

In "Function RcNumQ1", variable "RcNumQ" is not declared.

[hatmal]

new file attached with more Explain in excel sheet to


please help

[orange]

hatmal,

A few suggestions:
-write a description/explanation of the issue/calculation with example in your native language; then use Google translate to translate to English; then post the English description (Google translate is more than adequate for communication)
-every table should have a primary key
-every module should have Option Explicit at the start of the module.

[June7]

Starting to get a glimmer of what you are wanting.

Still confused by the Out penalty. Why would a later departure result in a deduction?

Over what date range should percentage be aggregated - a week, 2 weeks, a month, a pay period?