HELP WITH A QUERY

[NewComer]

I am creating a report based on a query of which I have enclosed the following SQL code. What I need to accomplish is if their are no records returned based on buno_no, it returns "No Discrepancies" in the discrepancy field. Thank you in advance for your help.

SELECT TBL_BUNO_INFO.BUNO_NO, TSYS_PHASE.PHASE_NO, TSYS_ACFT.IDENT, TBL_ENTRY_INFO.CARD_N0, TBL_ENTRY_INFO.TASK, TBL_BUNO_INFO.PRODUCTION_NO, TBL_BUNO_INFO.TOT_FLT_HRS, TSYS_DEFECT.DEFECT_CAT, TBL_BUNO_INFO.LT_SDLM_IMC_DATE, TBL_TASK_REQUIREMENTS.IMC_TASK_REQ, TBL_TASK_REQUIREMENTS.NOMEN, TBL_ENTRY_INFO.DISCREP_PART, TBL_ENTRY_INFO.DISCREPANCY, TBL_ENTRY_INFO.CORRECTIVE_ACTION, TBL_ENTRY_INFO.RPR_MHRS, TSYS_NDI_METHOD.NDI_METHOD, TSYS_TRADES.TRADE
FROM TSYS_DEFECT RIGHT JOIN ((TSYS_TRADES RIGHT JOIN ((TSYS_ACFT RIGHT JOIN ((TBL_BUNO_INFO INNER JOIN TBL_ENTRY_INFO ON TBL_BUNO_INFO.BUNO_ID = TBL_ENTRY_INFO.BUNO_ID) LEFT JOIN TSYS_PHASE ON TBL_BUNO_INFO.PHASE_NO = TSYS_PHASE.PHASE_NO) ON TSYS_ACFT.ACFT_ID = TBL_BUNO_INFO.ACFT_TYPE) LEFT JOIN TBL_TASK_REQUIREMENTS ON TBL_ENTRY_INFO.TASK = TBL_TASK_REQUIREMENTS.TASK) ON TSYS_TRADES.TRADE = TBL_ENTRY_INFO.TRADE) LEFT JOIN TSYS_NDI_METHOD ON TBL_ENTRY_INFO.NDI_METHOD = TSYS_NDI_METHOD.NDI_ID) ON TSYS_DEFECT.DEFECT_ID = TBL_ENTRY_INFO.CRITICAL_CODE
WHERE (((TBL_BUNO_INFO.BUNO_NO)=[ENTER A BUNO]) AND ((TBL_ENTRY_INFO.CORRECTIVE_ACTION) Is Not Null) AND ((TSYS_TRADES.TRADE)="NDI&quot)
ORDER BY TBL_ENTRY_INFO.CARD_N0;