Finding records that do not contain a date in field

C2680mor

Registered User.
Local time
Today, 12:52
Joined
Oct 22, 2004
Messages
17
I have database where users enter a date field when they have completed the work.

I am trying to return a query that finds all with this field empty(ie, not worked on) - i have tried like "null" and this has not worked.

Any help is appreciated.

Thanks
 
Put Is Null in the criteria.
 
Thanks, worked fine
 

Users who are viewing this thread

Back
Top Bottom