D
Dave Elliott
I have on my main form (3) fields to calculate the amount to Invoice the
customer
1. Text406 which equals the Hours , i.e. Man Hours
2. Text500 which equals the Rate , i.e. $65.00 an Hour
3. Text331 which equals the Suggested Price to Invoice the customer,
Formula for this is below
=Nz([Amount]+[Text330],0)/2 This is calculated from another form.
Here is my dilemna.
If there is one or two employees on the job the rate is 65. (For 1 employee
rate is 65, for 2 employees rate is 65)
if more than two employees, then the next employee is calculated at 1/2 of
the 65 which will be $32.50
and so on for each additional employee over 2.
customer
1. Text406 which equals the Hours , i.e. Man Hours
2. Text500 which equals the Rate , i.e. $65.00 an Hour
3. Text331 which equals the Suggested Price to Invoice the customer,
Formula for this is below
=Nz([Amount]+[Text330],0)/2 This is calculated from another form.
Here is my dilemna.
If there is one or two employees on the job the rate is 65. (For 1 employee
rate is 65, for 2 employees rate is 65)
if more than two employees, then the next employee is calculated at 1/2 of
the 65 which will be $32.50
and so on for each additional employee over 2.