Combining IIf expressions

[Pooks_35]

I need to build an expression that not only filters out the 9 in a column, but also the number 14. How do I build this expression to make it work for both 9 and 14. Currently it works just for 9. How do I make it work both numbers?

RegularPayment: IIf([tblPayments].[PaymentMethodID]<>9,[tblPayments].[PaymentAmount],Null)
​

 

[jdraw]

(untested)

RegularPayment: IIf([tblPayments].[PaymentMethodID]<>9 and [tblPayments].[PaymentMethodID]<>14,[tblPayments].[PaymentAmount],Null)

 

[CJ_London]

another alternative is

RegularPayment: IIf([tblPayments].[PaymentMethodID] not in (9,14),[tblPayments].[PaymentAmount],Null)

 

[Pooks_35]

Thank you for the assistance! Worked perfectly!