# 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.
###### Who is Participating?

x

Commented:
Sorry, just noticed that you're using access.....
``````Select FirstName & " " & LastName as Employee,
datediff("yyyy",birthdate,getdate()) as Age,
datediff("yyyy",hireddate,getdate()) as LengthOfService,
PresentSalary - PreviousSalary as SalaryRise,
((PresentSalary - PreviousSalary)/PreviousSalary) * 100 as SalaryRisePerCent
From EmployeeDetails
``````
0

Commented:
Do you have a table containing the correct information? ie employee, salary, date salary valid from,  etc
0

Author Commented:
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!
0

Commented:
Does this table contain multiple rows for each employee? ie a new row is added each time an employee is given a pay rise.
0

Commented:
Can you give me a sample of the table to work with?
0

Author Commented:

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 and PreviousSalaryEffectiveDate. I don't have any values in each given field but i need to calculate age, length of service, most recent salary increase both in dollars and as a percentage....
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.
0

Commented:
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.
``````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
``````
0

Commented:
...just use Date() instead of getDate() . Access doesn't recognize getDate() function
0

Commented:
D'oh! Thanks capricorn.....
0

Author Commented:
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?
0

Author Commented:
is this the right way to solve the time elapsed between the present and previous salary?: PresentSalaryEffectiveDate-PreviousSalaryEffectiveDate
0

Author Commented:
Hi. Thanks for helping me out.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.