C
Céline Brien
Hi everybody !
Employees accumulating seniority : 200 days = 1 year
If an employees has accumulated 278 days, I would like to show it as 1 year
78 days.
The following formula would do the job :
=IFF([Seniority]>200;"1 year " & ([Seniority]-200);[Seniority])
But what for employees with 12 years of seniority ? It would need to many
IFF
In Excel I would use this formula :
=ENT([Seniority]/200)&"year "&MOD([Seniority];200)
For 678
ENT([Seniority]/200) = 3
MOD([Seniority];200) = 78
How would you do it in Access ???
Many thanks for your help,
Céline
Employees accumulating seniority : 200 days = 1 year
If an employees has accumulated 278 days, I would like to show it as 1 year
78 days.
The following formula would do the job :
=IFF([Seniority]>200;"1 year " & ([Seniority]-200);[Seniority])
But what for employees with 12 years of seniority ? It would need to many
IFF
In Excel I would use this formula :
=ENT([Seniority]/200)&"year "&MOD([Seniority];200)
For 678
ENT([Seniority]/200) = 3
MOD([Seniority];200) = 78
How would you do it in Access ???
Many thanks for your help,
Céline