aşağıdaki sorgu kodunu dener misiniz?

SELECT [TAKIP LOG].*

FROM [TAKIP LOG] INNER JOIN (SELECT [TAKIP LOG].P1_RT_Report

FROM [TAKIP LOG]

WHERE ((([TAKIP LOG].p1_result)="R"))

union

SELECT [TAKIP LOG].P2_RT_Report

FROM [TAKIP LOG]

WHERE ((([TAKIP LOG].p2_result)="R"))

) as SqlP1_2 ON [TAKIP LOG].[RT Report No] = SqlP1_2.P1_RT_Report;