Invalid use of null 1

[pmaxon]

I am using VB6, CR8.5 with OCX and an access 2000 mdb database. To create one of my reports, I need to do a selection on a date field. As it turns out, there may not always be a date in the database. My sql is a follows:
sSQL = "SELECT Date_Closed " _
& "FROM Claim " _
& "ORDER BY Date_Closed "
and it errors off with "Invalid Use Of Null". Is there a way to make a selection which will not be errored off when it reaches a null value? I have tried "WHERE Date_Closed <> ''" and also tried > '', etc but they all error off.

Help Please?

TIA

 

[Katy44]

Have you tried 'where not isnull(Date_closed)'?

 

[pmaxon]

That worked splendidly Katy44. Thanks and a tip of the hat to you!

Pat