Eliminating blanks from a query

[Eirc]

How do I generate a query that if the end date is Null
then I do not want that record to show???

Here is a example of a query:

SELECT Plant.Name, User.Name, AnalysisTestGroup.StartDate,
AnalysisTestGroup.EndDate, AnalysisTestGroup.ID
FROM User INNER JOIN (Plant RIGHT JOIN AnalysisTestGroup
ON Plant.Code = AnalysisTestGroup.PlantCode) ON User.ID =
AnalysisTestGroup.TestPerson
WHERE (((AnalysisTestGroup.StartDate)>[Please Enter the
Start Date]))
ORDER BY AnalysisTestGroup.StartDate;

Any ideas?

 

[Darren]

WHERE (((AnalysisTestGroup.EndtDate) is Not Null))