Hi If I have 2 tables Table on

[kkgusta]

Hi
If I have 2 tables

Table one has:
-ProjectID
-BuildID
-ScriptID
-Script details

Table two has:
-ResultID
-ProjectID
-BuildID
-ScriptID
-Result


Query (QryReport) used to generate report
select T1.ProjectID
, T1.BuildID
, T1.ScriptID
, T2.ResultID
, T2.Result
from tableone as T1
left outer
join tabletwo as T2
on (
T2.ProjectID = T1.ProjectID
and T2.BuildID = T1.BuildID
and T2.ScriptID = T1.ScriptID
)


When I try to view the report with the following filter
T2.resultID is null it always return a blank report to me (I am certain that there are record with this criteria in the report). But the T2.resultID is NOT null is working fine. Is anyone here know why ?

DoCmd.OpenReport QryReport, acPreview, , “T2.resultID is null"

 

[kkgusta]

Please ignore this threat, problem fixed
Typo