I've read a ton of manuals and my head is swimming. I can't even find the words I need to nadin what I'm looking for.
I have 2 issues I need to take care of, the first playing into the second.
1) I have a
DateDiff function that returns a value in years but I need to convert that value into a designated text string, i.e.
Value | String |
2 | Over 2 |
3 | Over 3 |
4 | Over 4 |
5 | Over 4 |
6 | Over 6 |
7 | Over 6 |
8 | Over 8 |
9 | Over 8 |
etc
2) using the text string as returned above I need to cross-index that with the employee's pay rate code to find their monthly salary.
I don't even know what to call these functions to properly google them. If anyone could at least get me that far I'd be grateful and promise not to switch-out your Coco Puffs for a bunny surprise.