A question

  • Thread starter Thread starter Viktor via AccessMonster.com
  • Start date Start date
V

Viktor via AccessMonster.com

Hi all,

I didn't give a name to the thread because I'm not sure what would it be :)

Is this a legitimate worry:
Part of the database consists of two tables:

1. I have table employees - one of the fields is employeeRank
2. I have table Rank - field rnRankID (autonumber is FK in employees table)

The method for calculating salary is Salary=TotalHours*HourWage*Rank (Rank
has indirect values of 100, 110, 120, 130 and 140%)

People can get promoted and move up the rankings.

On another place I keep records (through a query) for all the payments for
the previous months.

Obviously, if a person gets promoted, the next times I look for all the
previous payments, all the payments would look as if that person has been
working from the begining with that rank.

I hope this makes sense. How do I solve this??

Thanks,
Viktor
 
In your payments history table store the Total Hours, Hour Wage and the Rank
Percentage.
 
... and I should base my query on this table, obviously :):).

Thank you, Bill
 
Back
Top