Access 2010

How to combine these IIf statements?

Product Line: IIF ([STATE CODE] In ("TX"),IIf [PROPERTY CODE] In ("6"), IIf[PRODUCT TYPE] In ("1"),"TX6","FR1")))

Subscribe to RSS - Access 2010