Date Range Search

  • Thread starter Thread starter Shree
  • Start date Start date
S

Shree

Hi!
I have a Date/Time column in my table that has some null
dates. I need to perform a search on date range from
another form that has the search text boxes. If the From
and To txt boxes are left empty and I run the query, no
record is found. But there are about 15 records that are
having no dates in them. I expected to find these 15
records in there. But I dont even get one record. Why is
that? How do I perform a search on null dates?
Thanks in Adance for any help.
Shree
 
search criteria = Is Null
if the from and to text boxes are expecting date criteria
and you provide none, then nothing will be returned.
You may need to write a seperate query to search for dates
that are null.
 
Back
Top