Calculate Invoice Amount?

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
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.
 
Hi,


So you have to have a field with the number of employee involved in the
.... process


Text500 could then be: iif(NumberOfEmployee <= 2, 1,
1+0.5*(NumberOfEmployee-2) )


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top