changing information

[Guest]

If I have a table of employees (2000) set up that has included increment
amounts
along with pay steps and due dates. Is there a way to find the due date it
will change the increment step and amount to the next one? example:
due date 5/1/2006
increment step: 7
increment amount: $19,000

new increment step would be: 8
new increment amount would be: $25,000

 

[Ardus Petus]

Could you post an example showing your data layout?

TIA

 

[Guest]

NAME- ADD- BUREAU- HIRE DATE- INCRE DATE- PAY GRADE- PAY STEP- AMOUN
...................................................5/1/2006...........7................5............$19,00
...................................................6/1/2006...........8.................1...........$23,00
...................................................6/1/2006...........7.................6...........$25,000

I want to be able to look at the increment date and if I am a pay step of a
5, it will change the pay step to 6 and change the increment amount to what a
6 would be. Would this be something access would do better?

 

[Ardus Petus]

Are you looking for a formula to calculate the amount?

If so, what are the rules?

I can't understand "change the increment amount to what a
6 would be".

Cheers,

 

[Guest]

What I want to do, if excel sees the pay step of a 6, it would add one to
make it a 7 and then change the increment amount to what a 7 would be. I
would have to a worksheet with pay steps and increment amounts so excel would
know when it sees a 6 to add 1 to make it a 7 and then look at the 7 step and
bring over the amount. I hope this is clear.

 

[Ardus Petus]

Column H (Amount) may contain eiter data ($25,000) or a formula that
calculates the new amount.

A VBA macro could do that, but not a formula.

HTH