SQL

[Guest]

What criteria do i use if i want to list all records
where a certain date field has no data

 

[Guest]

-----Original Message-----
What criteria do i use if i want to list all records
where a certain date field has no data
.
Is Null

 

[Joe B]

select * from Table where isNull(DateField)

 

[Joe B]

Sorry, I meant...
select * from Table where DateField IS NULL

I've been coding VB today and have been using isNull()