?
Solved

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

Posted on 2008-06-24
12
Medium Priority
?
1,266 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Bringing Advanced Authentication to the SMB Market

WatchGuard announces the acquisition of advanced authentication provider, Datablink, with one mission – to bring secure authentication to SMB, mid-market, and distributed enterprises with a cloud-based solution, ideal for resale via their established channel & MSSP community.

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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

771 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