Solved

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

Posted on 2008-06-24
12
1,264 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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

Expert Comment

by:Rey Obrero (Capricorn1)
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

This article outlines why you need to choose a backup solution that protects your entire environment – including your VMware ESXi and Microsoft Hyper-V virtualization hosts – not just your virtual machines.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

733 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