calculated fields and IIF function

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

Guest

I am trying to add a calculated field "BillTotal" which is the sum of
"OrderAmount" and "DeliveryCharge" fields, I also need to add a IFF function
to add "2" to the "BillTotal" field if the "City" field contains "Naples".
I can get the first part, the Sum, but can't figure out the IFF function.
 
I would tie a conditional macro to an event on your form.

Look for help on conditional macros and use the setvalue action.

Hope this helps
 
eric said:
I am trying to add a calculated field "BillTotal" which is the sum of
"OrderAmount" and "DeliveryCharge" fields, I also need to add a IFF function
to add "2" to the "BillTotal" field if the "City" field contains "Naples".
I can get the first part, the Sum, but can't figure out the IFF function.
Click to expand...

Try this:

BillTotal:
OrderAmount + DeliveryCharge + IIf(City = "Naples", 2, 0)
 
Back
Top