Solved

How do I calculate  salary increase and elapsed time between....

Posted on 2008-06-24
12
1,260 Views
Last Modified: 2013-12-27
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.
0
Comment
Question by:meena_26
  • 6
  • 5
12 Comments
 
LVL 7

Expert Comment

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

Author Comment

by:meena_26
ID: 21854295
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
 
LVL 7

Expert Comment

by:Chrisedebo
ID: 21854333
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
 
LVL 7

Expert Comment

by:Chrisedebo
ID: 21854377
Can you give me a sample of the table to work with?
0
 

Author Comment

by:meena_26
ID: 21855119

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
 
LVL 7

Expert Comment

by:Chrisedebo
ID: 21855278
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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
LVL 7

Accepted Solution

by:
Chrisedebo earned 500 total points
ID: 21855299
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
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 21855395
...just use Date() instead of getDate() . Access doesn't recognize getDate() function
0
 
LVL 7

Expert Comment

by:Chrisedebo
ID: 21855403
D'oh! Thanks capricorn.....
0
 

Author Comment

by:meena_26
ID: 21858795
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 Comment

by:meena_26
ID: 21858891
is this the right way to solve the time elapsed between the present and previous salary?: PresentSalaryEffectiveDate-PreviousSalaryEffectiveDate
0
 

Author Closing Comment

by:meena_26
ID: 31470076
Hi. Thanks for helping me out.
0

Featured Post

Give your grad a cloud of their own!

With up to 8TB of storage, give your favorite graduate their own personal cloud to centralize all their photos, videos and music in one safe place. They can save, sync and share all their stuff, and automatic photo backup helps free up space on their smartphone and tablet.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does your iMac really need a hardware upgrade? Will upgrading RAM speed-up your computer? If yes, then how can you proceed? Upgrading RAM in your iMac is not as simple as it may seem. This article will help you in getting and installing right RA…
Monitor input from a computer is usually nothing special.  In this instance it prevented anyone from using the computer.  This was a preconfiguration that didn't work.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now