Solved

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

Posted on 2008-06-24
12
1,259 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
Comment Utility
Do you have a table containing the correct information? ie employee, salary, date salary valid from,  etc
0
 

Author Comment

by:meena_26
Comment Utility
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
Comment Utility
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
Comment Utility
Can you give me a sample of the table to work with?
0
 

Author Comment

by:meena_26
Comment Utility

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
Comment Utility
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
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 7

Accepted Solution

by:
Chrisedebo earned 500 total points
Comment Utility
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
Comment Utility
...just use Date() instead of getDate() . Access doesn't recognize getDate() function
0
 
LVL 7

Expert Comment

by:Chrisedebo
Comment Utility
D'oh! Thanks capricorn.....
0
 

Author Comment

by:meena_26
Comment Utility
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
Comment Utility
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
Comment Utility
Hi. Thanks for helping me out.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

In the modern office, employees tend to move around the workplace a lot more freely. Conferences, collaborative groups, flexible seating and working from home require a new level of mobility. Technology has not only changed the behavior and the expe…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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…

772 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

10 Experts available now in Live!

Get 1:1 Help Now