Hi, i have a query salary which contains a this: "SID PK, autonum", "personId FK, text", "year, 4 digit, text", "General raise, number", "personal raise", "percent increase, double", and "total sum, number"
Ok, here's the challenge. Let say they you start in 1999 with a salary, next year which is 2000 you get a general and personal raise, the total sum should then contain the sum from last year (1999) added with general and personal raise and be put into sum for year 2000 for that particular person. Increase in salary from last year should be calculated as well and be put in percent raise. Next year 2001, the same should happen only with the number from 2000 and so on. Is it possible to do is in a elegant way.
I've thought of a opportunity to solve with creating two recordset, one based on a query, then next on the table salary. Then i would go and calculate for each person... Problem would be that if there's allot of record this will take time.
Any suggestion are welcome..
Pser
Ok, here's the challenge. Let say they you start in 1999 with a salary, next year which is 2000 you get a general and personal raise, the total sum should then contain the sum from last year (1999) added with general and personal raise and be put into sum for year 2000 for that particular person. Increase in salary from last year should be calculated as well and be put in percent raise. Next year 2001, the same should happen only with the number from 2000 and so on. Is it possible to do is in a elegant way.
I've thought of a opportunity to solve with creating two recordset, one based on a query, then next on the table salary. Then i would go and calculate for each person... Problem would be that if there's allot of record this will take time.
Any suggestion are welcome..
Pser