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

Improve company productivity with a Business Account.Sign Up

x
 
ChrisedeboConnect With a Mentor 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

Open in new window

0
 
ChrisedeboCommented:
Do you have a table containing the correct information? ie employee, salary, date salary valid from,  etc
0
 
meena_26Author 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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
ChrisedeboCommented:
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
 
ChrisedeboCommented:
Can you give me a sample of the table to work with?
0
 
meena_26Author 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
 
ChrisedeboCommented:
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

Open in new window

0
 
Rey Obrero (Capricorn1)Commented:
...just use Date() instead of getDate() . Access doesn't recognize getDate() function
0
 
ChrisedeboCommented:
D'oh! Thanks capricorn.....
0
 
meena_26Author 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
 
meena_26Author Commented:
is this the right way to solve the time elapsed between the present and previous salary?: PresentSalaryEffectiveDate-PreviousSalaryEffectiveDate
0
 
meena_26Author 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.

All Courses

From novice to tech pro — start learning today.