SELECT [TAKIP LOG].Field_Shop, [TAKIP LOG].[ISO-JOINT], [TAKIP LOG].[RT Report No], [TAKIP LOG].Result, [TAKIP LOG].Deleted, [TAKIP LOG].Repair, [TAKIP LOG].Repair_RT, [TAKIP LOG].P1_RT_Report, [TAKIP LOG].p1_result, [TAKIP LOG].P2_RT_Report, [TAKIP LOG].p2_result

FROM [TAKIP LOG] INNER JOIN [TAKIP LOG] AS [TAKIP LOG_1] ON [TAKIP LOG].[RT Report No] = [TAKIP LOG_1].P2_RT_Report

WHERE ((([TAKIP LOG].[RT Report No]) Is Not Null) AND (([TAKIP LOG].Result)="R") AND (([TAKIP LOG].p1_result)="R" Or ([TAKIP LOG].p1_result)="A") AND (([TAKIP LOG].p2_result)="R" Or ([TAKIP LOG].p2_result)="A"));

yukardaki sorgu kodunu dener misiniz?