Expand|Select|Wrap|Line Numbers
- IIf(([DATADUMP1-10].[Edition 1] Is Not Null And [DATADUMP1-10].[Status 1] Is Not Null) Or ([DATADUMP1-10].[Edition 1] Not Like "PN" And [DATADUMP1-10].[Status 1] Not Like "S") Or([DATADUMP1-10].[Edition 2] Not Like "PN" And [DATADUMP1-10].[Status 2] Not Like "S") Or ([DATADUMP1-10].[Edition 3] Not Like "PN" And [DATADUMP1-10].[Status 3] Not Like "S") Or ([DATADUMP1-10].[Edition 4] Not Like "PN" And [DATADUMP1-10].[Status 4] Not Like "S") Or ([DATADUMP1-10].[Edition 5] Not Like "PN" And [DATADUMP1-10].[Status 5] Not Like "S") Or ([DATADUMP1-10].[Edition 6] Not Like "PN" And [DATADUMP1-10].[Status 6] Not Like "S") Or ([DATADUMP1-10].[Edition 7] Not Like "PN" And [DATADUMP1-10].[Status 7] Not Like "S") Or ([DATADUMP1-10].[Edition 8] Not Like "PN" And [DATADUMP1-10].[Status 8] Not Like "S") Or ([DATADUMP1-10].[Edition 9] Not Like "PN" And [DATADUMP1-10].[Status 9] Not Like "S") Or ([DATADUMP1-10].[Edition 10] Not Like "PN" And [DATADUMP1-10].[Status 10] Not Like "S"),"Subscriber","NonSubscriber") AS Expr1,