Code:
SELECT IIf(IsNull([dl_qpt_cqe_QualMain].[MEASURES_ID]),Null,DLookUp("[HEDIS_MEASURE]","[dl_qpt_cqe_Measures]","[dl_qpt_cqe_Measures].[MEASURES_ID]=" & [dl_qpt_cqe_QualMain].[MEASURES_ID])) AS HEDISMeasure, IIf(IsNull([dl_qpt_cqe_QualMain].[MEASURES_ID]),Null,DLookUp("[SUB_MEASURE]","[dl_qpt_cqe_Measures]","[dl_qpt_cqe_Measures].[MEASURES_ID]=" & [dl_qpt_cqe_QualMain].[MEASURES_ID])) AS SubMeasure, IIf(IsNull([dl_qpt_cqe_QualMain].[YR_ID]),Null,DLookUp("[YR]","[dl_qpt_cqe_Year_Table]","[dl_qpt_cqe_Year_Table].[YR_ID]=" & [dl_qpt_cqe_QualMain].[YR_ID])) AS YR, IIf(IsNull([dl_qpt_cqe_QualMain].[MTH_ID]),Null,DLookUp("[MTH]","[dl_qpt_cqe_Month_Table]","[dl_qpt_cqe_Month_Table].[MTH_ID]=" & [dl_qpt_cqe_QualMain].[MTH_ID])) AS Mth, IIf(IsNull([dl_qpt_cqe_QualMain].[PROG_ID]),Null,DLookUp("[PROG_NM]","[dl_qpt_cqe_Program]","[dl_qpt_cqe_Program].[PROG_ID]=" & [dl_qpt_cqe_QualMain].[PROG_ID])) AS ProgNm, IIf(IsNull([dl_qpt_cqe_qualmain].[bus_id]),Null,DLookUp("[BUS_UNIT]","[dl_qpt_cqe_Bus_Unit]","[dl_qpt_cqe_Bus_Unit].[BUS_ID]=" & [dl_qpt_cqe_QualMain].[BUS_ID])) AS BusUnit, IIf(IsNull([dl_qpt_cqe_qualmain].[contact_id]),Null,DLookUp("[CONTACT]","[dl_qpt_cqe_Contacts]","[dl_qpt_cqe_Contacts].[CONTACT_ID]=" & [dl_qpt_cqe_QualMain].[CONTACT_ID])) AS Contact, IIf(IsNull([dl_qpt_cqe_qualmain].[freq_id]),Null,DLookUp("[FREQ]","[dl_qpt_cqe_Frequency]","[dl_qpt_cqe_Frequency].[FREQ_ID]=" & [dl_qpt_cqe_QualMain].[FREQ_ID])) AS Freq, IIf(IsNull([dl_qpt_cqe_QualMain].[STID]),Null,DLookUp("[STCD]","[dl_qpt_cqe_State]","[dl_qpt_cqe_State].[STID]=" & [dl_qpt_cqe_QualMain].[STID])) AS ST, IIf(IsNull([dl_qpt_cqe_QualMain].[LOB_ID]),Null,DLookUp("[LOB]","[dl_qpt_cqe_LOB]","[dl_qpt_cqe_LOB].[LOB_ID]=" & [dl_qpt_cqe_QualMain].[LOB_ID])) AS LOB, IIf(IsNull([dl_qpt_cqe_QualMain].[PROD_ID]),Null,DLookUp("[PROD_NM]","[dl_qpt_cqe_Product]","[dl_qpt_cqe_Product].[PROD_ID]=" & [dl_qpt_cqe_QualMain].[PROD_ID])) AS ProdNM, IIf(IsNull([dl_qpt_cqe_QualMain].[COMM_ID]),Null,DLookUp("[COMM_TYPE]","[dl_qpt_cqe_Communication]","[dl_qpt_cqe_Communication].[COMM_ID]=" & [dl_qpt_cqe_QualMain].[COMM_ID])) AS CommType, IIf(IsNull([dl_qpt_cqe_QualMain].[COMM_LVL_ID]),Null,DLookUp("[COMM_LVL]","[dl_qpt_cqe_Comm_LVL]","[dl_qpt_cqe_Comm_LVL].[COMM_LVL_ID]=" & [dl_qpt_cqe_QualMain].[COMM_LVL_ID])) AS CommLvl, DL_QPT_CQE_qualmain.q1update, DL_QPT_CQE_qualmain.q2update, DL_QPT_CQE_qualmain.q3update, DL_QPT_CQE_qualmain.q4update, DL_QPT_CQE_qualmain.qid, DL_QPT_CQE_qualmain.prog_entdt, DL_QPT_CQE_qualmain.attachment
FROM DL_QPT_CQE_year_table INNER JOIN (DL_QPT_CQE_state INNER JOIN (DL_QPT_CQE_program INNER JOIN (DL_QPT_CQE_product INNER JOIN (DL_QPT_CQE_month_table INNER JOIN (DL_QPT_CQE_measures INNER JOIN (DL_QPT_CQE_lob INNER JOIN (DL_QPT_CQE_frequency INNER JOIN (DL_QPT_CQE_contacts INNER JOIN (DL_QPT_CQE_communication INNER JOIN (DL_QPT_CQE_comm_lvl INNER JOIN (DL_QPT_CQE_bus_unit INNER JOIN DL_QPT_CQE_qualmain ON DL_QPT_CQE_bus_unit.bus_id = DL_QPT_CQE_qualmain.bus_id) ON DL_QPT_CQE_comm_lvl.comm_lvl_id = DL_QPT_CQE_qualmain.comm_lvl_id) ON DL_QPT_CQE_communication.comm_id = DL_QPT_CQE_qualmain.comm_id) ON DL_QPT_CQE_contacts.contact_id = DL_QPT_CQE_qualmain.contact_id) ON DL_QPT_CQE_frequency.freq_id = DL_QPT_CQE_qualmain.freq_id) ON DL_QPT_CQE_lob.lob_id = DL_QPT_CQE_qualmain.lob_id) ON DL_QPT_CQE_measures.measures_id = DL_QPT_CQE_qualmain.measures_id) ON DL_QPT_CQE_month_table.mth_id = DL_QPT_CQE_qualmain.mth_id) ON DL_QPT_CQE_product.prod_id = DL_QPT_CQE_qualmain.prod_id) ON DL_QPT_CQE_program.prog_id = DL_QPT_CQE_qualmain.prog_id) ON DL_QPT_CQE_state.stid = DL_QPT_CQE_qualmain.stid) ON DL_QPT_CQE_year_table.yr_id = DL_QPT_CQE_qualmain.yr_id
WHERE (((IIf(IsNull([dl_qpt_cqe_QualMain].[MEASURES_ID]),Null,DLookUp("[HEDIS_MEASURE]","[dl_qpt_cqe_Measures]","[dl_qpt_cqe_Measures].[MEASURES_ID]=" & [dl_qpt_cqe_QualMain].[MEASURES_ID]))) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((IIf(IsNull([dl_qpt_cqe_QualMain].[MEASURES_ID]),Null,DLookUp("[SUB_MEASURE]","[dl_qpt_cqe_Measures]","[dl_qpt_cqe_Measures].[MEASURES_ID]=" & [dl_qpt_cqe_QualMain].[MEASURES_ID]))) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((IIf(IsNull([dl_qpt_cqe_QualMain].[YR_ID]),Null,DLookUp("[YR]","[dl_qpt_cqe_Year_Table]","[dl_qpt_cqe_Year_Table].[YR_ID]=" & [dl_qpt_cqe_QualMain].[YR_ID]))) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((IIf(IsNull([dl_qpt_cqe_QualMain].[MTH_ID]),Null,DLookUp("[MTH]","[dl_qpt_cqe_Month_Table]","[dl_qpt_cqe_Month_Table].[MTH_ID]=" & [dl_qpt_cqe_QualMain].[MTH_ID]))) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((IIf(IsNull([dl_qpt_cqe_QualMain].[PROG_ID]),Null,DLookUp("[PROG_NM]","[dl_qpt_cqe_Program]","[dl_qpt_cqe_Program].[PROG_ID]=" & [dl_qpt_cqe_QualMain].[PROG_ID]))) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((IIf(IsNull([dl_qpt_cqe_qualmain].[bus_id]),Null,DLookUp("[BUS_UNIT]","[dl_qpt_cqe_Bus_Unit]","[dl_qpt_cqe_Bus_Unit].[BUS_ID]=" & [dl_qpt_cqe_QualMain].[BUS_ID]))) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((IIf(IsNull([dl_qpt_cqe_qualmain].[contact_id]),Null,DLookUp("[CONTACT]","[dl_qpt_cqe_Contacts]","[dl_qpt_cqe_Contacts].[CONTACT_ID]=" & [dl_qpt_cqe_QualMain].[CONTACT_ID]))) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((IIf(IsNull([dl_qpt_cqe_qualmain].[freq_id]),Null,DLookUp("[FREQ]","[dl_qpt_cqe_Frequency]","[dl_qpt_cqe_Frequency].[FREQ_ID]=" & [dl_qpt_cqe_QualMain].[FREQ_ID]))) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((IIf(IsNull([dl_qpt_cqe_QualMain].[STID]),Null,DLookUp("[STCD]","[dl_qpt_cqe_State]","[dl_qpt_cqe_State].[STID]=" & [dl_qpt_cqe_QualMain].[STID]))) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((IIf(IsNull([dl_qpt_cqe_QualMain].[LOB_ID]),Null,DLookUp("[LOB]","[dl_qpt_cqe_LOB]","[dl_qpt_cqe_LOB].[LOB_ID]=" & [dl_qpt_cqe_QualMain].[LOB_ID]))) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((IIf(IsNull([dl_qpt_cqe_QualMain].[PROD_ID]),Null,DLookUp("[PROD_NM]","[dl_qpt_cqe_Product]","[dl_qpt_cqe_Product].[PROD_ID]=" & [dl_qpt_cqe_QualMain].[PROD_ID]))) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((IIf(IsNull([dl_qpt_cqe_QualMain].[COMM_ID]),Null,DLookUp("[COMM_TYPE]","[dl_qpt_cqe_Communication]","[dl_qpt_cqe_Communication].[COMM_ID]=" & [dl_qpt_cqe_QualMain].[COMM_ID]))) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((IIf(IsNull([dl_qpt_cqe_QualMain].[COMM_LVL_ID]),Null,DLookUp("[COMM_LVL]","[dl_qpt_cqe_Comm_LVL]","[dl_qpt_cqe_Comm_LVL].[COMM_LVL_ID]=" & [dl_qpt_cqe_QualMain].[COMM_LVL_ID]))) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((DL_QPT_CQE_qualmain.q1update) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((DL_QPT_CQE_qualmain.q2update) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((DL_QPT_CQE_qualmain.q3update) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((DL_QPT_CQE_qualmain.q4update) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((DL_QPT_CQE_qualmain.qid) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((DL_QPT_CQE_qualmain.prog_entdt) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((DL_QPT_CQE_qualmain.attachment) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((IIf(IsNull([dl_qpt_cqe_QualMain].[LOB_ID]),Null,DLookUp("[LOB]","[dl_qpt_cqe_LOB]","[dl_qpt_cqe_LOB].[LOB_ID]=" & [dl_qpt_cqe_QualMain].[LOB_ID]))) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((IIf(IsNull([dl_qpt_cqe_QualMain].[PROD_ID]),Null,DLookUp("[PROD_NM]","[dl_qpt_cqe_Product]","[dl_qpt_cqe_Product].[PROD_ID]=" & [dl_qpt_cqe_QualMain].[PROD_ID]))) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((IIf(IsNull([dl_qpt_cqe_QualMain].[COMM_ID]),Null,DLookUp("[COMM_TYPE]","[dl_qpt_cqe_Communication]","[dl_qpt_cqe_Communication].[COMM_ID]=" & [dl_qpt_cqe_QualMain].[COMM_ID]))) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((IIf(IsNull([dl_qpt_cqe_QualMain].[COMM_LVL_ID]),Null,DLookUp("[COMM_LVL]","[dl_qpt_cqe_Comm_LVL]","[dl_qpt_cqe_Comm_LVL].[COMM_LVL_ID]=" & [dl_qpt_cqe_QualMain].[COMM_LVL_ID]))) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((DL_QPT_CQE_qualmain.q1update) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((DL_QPT_CQE_qualmain.q2update) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((DL_QPT_CQE_qualmain.q3update) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((DL_QPT_CQE_qualmain.q4update) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((DL_QPT_CQE_qualmain.qid) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((DL_QPT_CQE_qualmain.prog_entdt) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*")) OR (((DL_QPT_CQE_qualmain.attachment) Like "*" & [forms]![frmProgramsUpdate].[txtSearch] & "*"));