Any recommendations?

[pablofonto]

Hello Everyone,

I was given this project and I'm not sure how to start it. I have a table (Employees) that need to receive salary increases based on their level. Their level is calculated based on their time with the company, but some are base on hours worked and some based on days worked. For example my table looks like this;

Name PSG Hire date
Peter 037-30-1 06/01/2005
John 051-21-1 09/15/20005

There are different rules for the PSG, as I said earlier some calculate their level in days and some on hours worked. Example

PSG Level Rule
037-30-1 01 1st 1000 worked hrs
02 2nd 1000 worked hrs
03 3rd 1000 worked hrs
021-21-1 01 0 - 80 worked Days
02 81 - 160 worked Days
03 161 - 240 worked Days

I need to create a table or report that will populate the correct LEVEL to the employee depending on what their PSG is. Any ideas?

Please help!

thanks,

Pablo

 

[ScottGem]

Just run an update query matching the PSG

 

[pablofonto]

Thank you Scott!

I already solved the problem. I end up creating a code using IIF and SWITCH with the rules for each PSG and it worked great.

Pablo