Make one field NZ when data is entered in another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a form in which one field [Labor Cost 60%] automatically
calculates 60% of the Contract cost field. However, I have a field titled
[Labor Cost Known]; If I enter data in that field, I would like the [Labor
Cost 60%] field to be automatically 0.
 
In the control source of the [Labor Cost 60%] field you can write

=IIf([Labor Cost Known]>0 and [Labor Cost Known] Is Not Null,0,[Contract
cost]*.60)

The Labor Cost 60% is a calculated field, and I hope you are not storing it
value in a table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with an expression to calculate a profit from one of three fi 2
Calculated Fields on a Form 3
Multiplying the number in one cell and providing the product in an 4
Form comes out blank with no fields to enter data 2
Values calculated in a Form entered in the Table? 6
Default value depending on previous field 5
Total cost stored in a field 2
Calculating the Sum IF fields equal criteria 6

Back
Top