Checking a date field for no entry

[Catrina]

I have a date field that holds termination date. I need to create a query to find all employees with no term dates. I have tried IsNull, =NULL, ="", and =" " none of these work. How can I search for an empty Date Field. Thanks in advance.

Catrina

 

[WP]

Catrina, the SQL syntax is just:

SELECT * FROM table WHERE DateField Is Null;



Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out my website !