Calculated Field with Multiple Conditions

[whisp0214]

I want to create a calculated field based on two other fields. The calculated field will be the payment due date. Companies pay either Monthly, Quarterly, Bi-Annually or Annually. How they pay is stored in one field(Payment_Frequency), and the shipment date(Ship_Date) is stored in another. The calculated value will use the ship date to create the payment due date, but it needs to check the Payment_Frequency to see how to calculate it. In essence it is an If/Then/Else statement, but I can't figure out how to do that in a query. Any suggestions?



Thanks in advance!

[June7]

Use IIf() or Switch() or Choose() functions in query.

[whisp0214]

The switch function works nicely, so thanks June7.