If formula

[Sed]

Calling all experts,

Would somebody please help me with a query formula. I have 4 fields, Shipping Mode (which have 3 options, Ocean, Air and Broker). Depending on what they choose, it will calculate appropriately in a separate column. So...my issue is, I want to add another column called "Premium Cost". Depending on what they choose, it will bring that column in. I hope I made myself clear. Thanks in advance.

 

[jdraw]

Not clear. What have you got now?
Query or vba?

 

[Sed]

Jdraw,

Nevermind, I figured it out. Here what I did.
Premium_Cost: IIf([Mode]="Ocean",[OceanCost],IIf([Mode]="Broker",[BrokerCost],IIf([Mode]="Small Package",[AirCost],"No")))
Thanks, you guys are a great help through all of this. I truely appreciate this site.