I have 20 numbers I am trying to isolate so I built the following and it gives me the "too complex" message.
Would you have a better idea on how to run this query? Thanks a lot.
wp
DVT_Eligible: IIf(tbl_NextGen_Working_Table!CPT4="99221",1,IIf(t bl_NextGen_Working_Table!CPT4="99222",1,IIf(tbl_Ne xtGen_Working_Table!CPT4="99223",1,IIf(tbl_NextGen _Working_Table!CPT4="99218",1,IIf(tbl_NextGen_Work ing_Table!CPT4="99219",1,IIf(tbl_NextGen_Working_T able!CPT4="99220",1,IIf(tbl_NextGen_Working_Table! CPT4="99231",1,IIf(tbl_NextGen_Working_Table!CPT4= "99232",1,IIf(tbl_NextGen_Working_Table!CPT4="9923 3",1,IIf(tbl_NextGen_Working_Table!CPT4="99234",1, IIf(tbl_NextGen_Working_Table!CPT4="99235",1,IIf(t bl_NextGen_Working_Table!CPT4="99236",1,IIf(tbl_Ne xtGen_Working_Table!CPT4="99238",1,IIf(tbl_NextGen _Working_Table!CPT4="99239",1,IIf(tbl_NextGen_Work ing_Table!CPT4="99281",1,IIf(tbl_NextGen_Working_T able!CPT4="99282",1,IIf(tbl_NextGen_Working_Table! CPT4="99283",1,IIf(tbl_NextGen_Working_Table!CPT4= "99284",1,IIf(tbl_NextGen_Working_Table!CPT4="9928 5",1,IIf(tbl_NextGen_Working_Table!CPT4="99291",1, 0))))))))))))))))))))