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

Could you post an example showing your data layout?

TIA
--
AP

"Pammy" <(E-Mail Removed)> a écrit dans le message de news:
E3E6675C-EA0F-402F-8C0A-(E-Mail Removed)...
> 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
>

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" wrote:

> Could you post an example showing your data layout?
>
> TIA
> --
> AP
>
> "Pammy" <(E-Mail Removed)> a écrit dans le message de news:
> E3E6675C-EA0F-402F-8C0A-(E-Mail Removed)...
> > 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
> >
>
>
>

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,
--
AP

"Pammy" <(E-Mail Removed)> a écrit dans le message de news:
2D4E5046-D37A-4789-95DC-(E-Mail Removed)...
> NAME- ADD- BUREAU- HIRE DATE- INCRE DATE- PAY GRADE- PAY STEP- AMOUNT
> ..................................................5/1/2006...........7................5............$19,000
> ..................................................6/1/2006...........8.................1...........$23,000
> ..................................................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" wrote:
>
>> Could you post an example showing your data layout?
>>
>> TIA
>> --
>> AP
>>
>> "Pammy" <(E-Mail Removed)> a écrit dans le message de
>> news:
>> E3E6675C-EA0F-402F-8C0A-(E-Mail Removed)...
>> > 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
>> >
>>
>>
>>

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.

"Pammy" wrote:

> 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
>

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
--
AP

"Pammy" <(E-Mail Removed)> a écrit dans le message de news:
0161BC8F-9B34-426E-B66A-(E-Mail Removed)...
> 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.
>
> "Pammy" wrote:
>
>> 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
>>