SELECT AWEB_B_REQUIREMENT.DISCR_DISPLAY, AWEB_B_REQUIREMENT.REQ_ID, AWEB_B_REQUIREMENT.REQ_NO, AWEB_C_MAINTENANCE_HISTORY_INFO.IND_DATE, AWEB_B_SPECIFICATION.RETIRE_DATE
FROM ((AWEB_C_MAINTENANCE_HISTORY_INFO INNER JOIN (((AWEB_B_REQUIREMENT INNER JOIN AWEB_B_SPECIFICATION ON AWEB_B_REQUIREMENT.SPEC_ID = AWEB_B_SPECIFICATION.SPEC_ID) INNER JOIN AWEB_C_LOV_ACFT ON AWEB_B_SPECIFICATION.ACFT_ID = AWEB_C_LOV_ACFT.ACFT_ID) INNER JOIN AWEB_C_DISCREPANCY_INFO ON AWEB_B_REQUIREMENT.REQ_ID = AWEB_C_DISCREPANCY_INFO.REQ_ID) ON AWEB_C_MAINTENANCE_HISTORY_INFO.INSP_ID = AWEB_C_DISCREPANCY_INFO.INSP_ID) INNER JOIN AWEB_C_BUNO_INFO ON (AWEB_C_LOV_ACFT.ACFT_ID = AWEB_C_BUNO_INFO.ACFT_ID) AND (AWEB_C_MAINTENANCE_HISTORY_INFO.BUNO_ID = AWEB_C_BUNO_INFO.BUNO_ID)) INNER JOIN FDDR_Discrepancy_Details ON (AWEB_B_REQUIREMENT.REQ_NO = FDDR_Discrepancy_Details.REQ_NO) AND (AWEB_C_MAINTENANCE_HISTORY_INFO.JON = FDDR_Discrepancy_Details.JON)
WHERE (((AWEB_B_REQUIREMENT.DISCR_DISPLAY)=True) AND ((AWEB_C_MAINTENANCE_HISTORY_INFO.IND_DATE)<[AWEB_B_SPECIFICATION]![RETIRE_DATE] And (AWEB_C_MAINTENANCE_HISTORY_INFO.IND_DATE)>[AWEB_B_SPECIFICATION]![RETIRE_DATE])) OR (((AWEB_B_SPECIFICATION.RETIRE_DATE) Is Null));
okay, this query is running very slow and not returning records. do you see any obvious problems?