Access 2013 Nested IIF Update Query Help

[Mac1206]

I have 2 Tables with a one-to-one join. (A)Price_Tbl and (B)Freight_Tbl which I need to update (A)Tbl.Cost_Fld....
IIF (A)Price_Tbl.Cond_Fld = "Truck", "Not Assigned", "Truck with Tarp"---pull the rate from (B)Freight_Tbl.Rate_40,
IIF (A)Price_Tbl.Cond_Fld = "Train", "Railway", "Flat Car"---pull the rate from (B)Freight_Tb.Rate_RR
IIF (A)Price_Tbl.Cond_Fld = "Multimodal"---pull the rate from (B)Freight_Tb.Rate_MM
Then multiply everything 20

Thanks in advance for your possible help....

 

[Mac1206]

Yes, you can. But you said you wanted to use macros so a VBA function may not be what you are looking for.

Edit: What I mean is, that people who use macros (mainly) generally do not want to involve VBA in their applications. Otherwise, they'd just use vba and forget the macros. VBA can always do the same, and more, than the macros, but the security context is different so they are not apples to apples.

Roger that, thanks...