meena_26
asked on
How do I calculate salary increase and elapsed time between....
Hi,
I am faced with a scenario in finding an employee's salary increase, both in dollars and as a percentage of the previous salary. Calculate how long the employee had towait for that increase and how much time has elapsed between the present and previous salary.
I am new to access and would be happy to learn from your expertise.
I am faced with a scenario in finding an employee's salary increase, both in dollars and as a percentage of the previous salary. Calculate how long the employee had towait for that increase and how much time has elapsed between the present and previous salary.
I am new to access and would be happy to learn from your expertise.
Do you have a table containing the correct information? ie employee, salary, date salary valid from, etc
ASKER
Hi Chrisdebo:
Yes, I do have a simple table wherein there's a list of emloyee, salary, hired date, salary effective date. My problem is, how to calculate employee's salary both in dollars and percentage of the previous salary. And to calculate how long the employee had towait for that increase and how much time has elapsed between the present and previous salary.
Looking forward to your solution. Thanks!
Yes, I do have a simple table wherein there's a list of emloyee, salary, hired date, salary effective date. My problem is, how to calculate employee's salary both in dollars and percentage of the previous salary. And to calculate how long the employee had towait for that increase and how much time has elapsed between the present and previous salary.
Looking forward to your solution. Thanks!
Does this table contain multiple rows for each employee? ie a new row is added each time an employee is given a pay rise.
Can you give me a sample of the table to work with?
ASKER
I am jst given a scenario in here wherein I am going to track employee compensation. I am asked to find a lot of stuff like age of every employee as well. So, I started by making a table first with EmployeeID, LastName, FirstName, Birthdate,HiredDate, PresentSalary, PreviousSalary, PresentSalaryEffectiveDate
First, I created a table, then a query, then a form. the problem is how to calculate them,
I hope i answered your question; you got my full cooperation to solve this matter.
If all the information is contained in one row in the SQL table then it should just be a case of doing some simple calculations.
Eg.
Eg.
Select FirstName + ' ' + LastName as Employee,
datediff(y,birthdate,getdate()) as Age,
datediff(y,hireddate,getdate()) as LengthOfService,
PresentSalary - PreviousSalary as SalaryRise,
((PresentSalary - PreviousSalary)/PreviousSalary) * 100 as SalaryRisePerCent
From EmployeeDetails
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
...just use Date() instead of getDate() . Access doesn't recognize getDate() function
D'oh! Thanks capricorn.....
ASKER
Thanks, guys. I just wonder, should i just type in the formula to the table?Or should I do it on the Form?It's my very first time to use Access and you have been a great help.
P.S. How to determine employee's recent performance given the data above?
P.S. How to determine employee's recent performance given the data above?
ASKER
is this the right way to solve the time elapsed between the present and previous salary?: PresentSalaryEffectiveDate -PreviousS alaryEffec tiveDate
ASKER
Hi. Thanks for helping me out.