Solved

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

Posted on 2008-06-24
1,259 Views
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
Question by:meena_26
• 6
• 5

LVL 7

Expert Comment

Do you have a table containing the correct information? ie employee, salary, date salary valid from,  etc
0

Author Comment

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

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

Can you give me a sample of the table to work with?
0

Author Comment

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

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
``````
0

LVL 7

Accepted Solution

Chrisedebo earned 500 total points
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
``````
0

LVL 119

Expert Comment

...just use Date() instead of getDate() . Access doesn't recognize getDate() function
0

LVL 7

Expert Comment

D'oh! Thanks capricorn.....
0

Author Comment

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

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

Author Closing Comment

Hi. Thanks for helping me out.
0

## Featured Post

pc, laptop  monitor connection configurations
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…