Payroll

I am preparing for a payroll aplication and I want your advice in a design
problem.
The salary of every employee increases at the begining of every fiscal year,
and in rare cases it increases during the fiscal year (in addition to the
increase at the beginning of the fiscal year)
How to design the table(s) that contain the salary, so that the new salary
does not replace the older salaries for the same employee?
Thanks

Marwan

It sounds like you wish to preserve historical records of employees'
salaries.

To do that you need a table with the employee, the salary, and the BeginDate
and EndDate. This would be an EmployeeSalary table, and would use the
EmployeeID from an Employee table. With a design like this, you would be
able to look at a salary "history" for a single employee by returning all
rows where EmployeeID = (whatever you chose).

--
Good luck

Jeff Boyce
Access MVP

I'm not sure what your Access skill level is or what your payroll
application "requirements" are but I would consider purchasing a payroll
system. There are systems such as those found at
http://www.databasecreations.com.

If you have lots of time, excellent Access and accounting knowledge, and the
ability to deal with HR and Accounting co-workers AND you want a good
challenge, then go ahead.

--
Duane Hookom
MS Access MVP


"marwan" wrote in message
...
I am preparing for a payroll aplication and I want your advice in a design
problem.
The salary of every employee increases at the begining of every fiscal
year,
and in rare cases it increases during the fiscal year (in addition to the
increase at the beginning of the fiscal year)
How to design the table(s) that contain the salary, so that the new salary
does not replace the older salaries for the same employee?
Thanks