Query Criterion Question

[OxDavis]

Ok, I made a query that returns a Case Manager, their associated cases, and 3 dates that relate to each of these cases. So its:

Case Manager-----Case Name----Date1-----Date2-----Date3

I only want records to appear that have a value in at least 1 of the 3 date fields. If they have no data in ANY of the date fields I want those records excluded. How do I build this?

 

[FoFa]

WHERE (Date1 is not null OR Date2 is not null OR Date3 is not null)

 

[OxDavis]

Thanks again Fofa! My lack of knowledge about SQL syntax strikes again!

 

[OxDavis]

Thanks again Fofa! My lack of knowledge about SQL syntax strikes again!