IIF Then

[Guest]

I have 2 fields that I want the response from 1 (Can Item Be Reworked) that
has 2 possible choices from a lookup (Scrap/Rework or Return To Inventory) to
update the 2nd field depending on the choice. If Scrap/Rework then I want
the 2nd. field to Calculate Freight + Value Of Item and update the field, if
Return To Inventory then 0 to the field. The 2nd. field is called Value Of
Rework.

 

[Guest]

You don't say how to Caclulate Fright or to get the value of the item. But
if I assumed Caculate Fright was some function and value of item was a field
in the table this could work:

=iif(field1="Scrap/Rework",CalcFreight()+Value_Of_Item,0)

-Steve Huff