Ok, your maths does not make any sense.
First, they worked 19, so I figure that's level 1 all sown up
They work another 20, so I figure that's 10 more at level 2
and 10 more at level 3
your example says if 20 more, then
level 1: 1hr
level 2: 10hr
level 3: 8hr
I realise that adds up to 19, not 39 (19+20). If we are adding up the
initial 19, then what had the 20 to do with any of this?.
Also, why is there 1hr at level 1 at all when 19 hours had already been
satisfied.
You can't figure this out because, to me, your question didn't make any
sense.
Dominic Vella
<sa****@gmail.comwrote in message
news:45**********************************@d4g2000p rg.googlegroups.com...
>I am developing a db and i have 3 rate levels. the subcontractor
begins at level1 (1-19 hours). when she performs 20-29 hours they fall
into level 2 and 30+ falls into level 3. I have the payrates in a
table attached to the client because of fluctuation of pay rates
between clients. i need to spit out total amount owed to the
subcontractor.
my problem is this. If they currently have 19 hours and they performed
an additional 20 during this period i will need to bill 1 hour at
level 1;10 hours at level 2 and another 8 at level 3. Can someone
please help me figure this out