Thanks all! Your suggestion helps me a lot.
Thanks I got the answer.
SamuelTad
Last Activity: Sep 18 '14, 08:22 AM
Joined: Jul 25 '14
Location:
-
-
Payroll database
Wow!!! Thank you all who support me a lot to change an ideal one in to real Database.
One more question,In my database I have fields called [status] and [Basic Salary].
If [Status] = No, meaning eligible for pension deduction.
So, Pension: [Basic salary]*0.07
Else,
[Status] = Yes, meaning not eligible.
Pension: 0
Therefore I need an expression which executes it.
With regards!!! -
Wow!!! Thank you all who support me a lot to change an ideal one in to real Database.Leave a comment:
-
Ok sir am tying to explain it better.well every employee grants 14 days entitle date for 1st year and continue 15 ... where,year=12.
So far my question regarding available days i mentioned were mistakes.The first entitled date which is 14 days take as a constant to calculate the Available days.But it is clear that employee can take leave so available days automatically decrease so consider my point and support me to finish my project. ...Leave a comment:
-
Thank you @NeoPa!!
one more question!
Available Days:14+IIf(Y<1 1,Y,11) on this do not take 14 is a constant rather first year entitle date.So it can be zero when employee use it.Remember am an Amateur on programming so i hope you tolerate me.Leave a comment:
-
Thanks @Neopa,OK to draw the company i work for is a Herbal farm,It's man power is very few management stuff and 400 ordinary staff.even if they differ in position but Similar Entitled Date .So our intention is to manege the 400 people annual leave system.Leave a comment:
-
Thanks Seth your formula is workable.In my database there is Date of employ column in DD.MM.YYYY format.How can number of years worked count by taking Date of Employ .With regard!!!!
Finally my intention is the system to show me this,
Available Days:14+(Nz[Date of employ]-1)Leave a comment:
-
Sorry inconvenience that i made @ Seth!would mind able to understand me in such manner.
1st year grant 14 days
2nd year grant 15 days
.
.
.
12nd year granted 25 days.So it will stop at this time.So it is not the total number of days granted rather i want mentioned that granted date increment with 1 day for every consecutive years.Thank you!!Leave a comment:
-
Thank you All.I was stressed only on code rather than fulfilling all requirements,bu t i understood that maximum days entitled is a part of a code so it is 25 days.
@ NeoPa my inquiry is
1.Code which Implement annual leave.
2.You can take the same Entitled Days for employee.
***One thing to remind if i get any clue i will manage in for different position.Thanks !!Leave a comment:
-
Thanks for your concern!@Seth
No matter how many year employee can work in the company.However ,employee has to consume entitled no of days within the year before new Entitle days released.The first year entitled annual leave shall be used on that first year only unless some exceptional case.I need SQL based.
Entitled Days for 1st,begin with 14 days
2nd year,14 days + 15 Days = 29 Days
it goes like this.Leave a comment:
-
Annual leave format
Hi All,
Am trying some Annual leave database.
It's Idea is
Annual leave:[Date of Employ]+1,for 1st year=14 days
for 2nd year=14+(14+1)
.
.
.
I need the expression which execute Annual leave in my case. with regard! -
SamuelTad replied to It is a formula in excel to execute employee tax,meanwhile i want to use it Access.soin AccessCheer,thanks a lot it works!!Leave a comment:
-
SamuelTad replied to It is a formula in excel to execute employee tax,meanwhile i want to use it Access.soin AccessHi Twinny appreciate for quick respond!!
I put everything in this manner but it says syntax error...Code:iif([Gross Salary]>[5000] ,[Gross Salary]*[0.35-662.5] ,IF([Gross Salary]>[3551] ,[Gross Salary]*[0.3-412.5] ,iif([Gross Salary]>[2351] ,[Gross Salary]*[0.25-235] ,iif([Gross Salary]>[1401] ,[Gross Salary]*[0.2-117.5]Last edited by zmbd; Aug 1 '14, 12:10 AM. Reason: [z{placed required code tags}{stepped the code for reading}]Leave a comment:
-
SamuelTad replied to It is a formula in excel to execute employee tax,meanwhile i want to use it Access.soin AccessWell to make my self clear,P5 is Gross salary,therefor e if salary is > $5000.00 tax is undergoes like "P5 * 35% then subtract 662.5 from the new Gross salary" up to the least salary.so convert this formula in to access expression.than ks!!Leave a comment:
-
SamuelTad started a topic It is a formula in excel to execute employee tax,meanwhile i want to use it Access.soin AccessIt is a formula in excel to execute employee tax,meanwhile i want to use it Access.so
WhereCode:=if(p5>5000,p5*0.35-662.5,if(p5>3551,p5*0.3412.5,if(p5>2351,p5*0.25-235,if(p5>1401,p5*0.2-117.5,if(p5>651,p5*0.15-47.5,if(p5>=151,p5*0.1-15,0))))))
P5=Gross salary
No activity results to display
Leave a comment: