dates query

[Guest]

I'm trying to run a query in a database of properties for sale which would
select only properties with no sale date. how do i write that query? thanks!

 

[Allen Browne]

In the Criteria row under your date field, enter:
Null

Nulls are funny beasts if you have not worked with them before. For an
introduction, see:
Nulls: Do I need them?
at:
http://members.iinet.net.au/~allenbrowne/casu-11.html