On Sun, 2009-05-31 at 06:41 -0400, Drew Jensen wrote: > Keith Bates wrote: > > I have a database table where I keep details of the fish in my tank. > > > > One of the fields is the date when the fish died. > > > > I want to make a list of currently living fish by searching for records > > where the date of death is blank. > > > > What do I need to enter in the query to find this? > > > > I've tried, in the query view "", space, NULL and 0, but none produces > > the correct result. > > > > The field is specified to be a date field. > > > > Thanks > > Try > > EMPTY > > Drew > > -- >
Thanks Drew, but that comes up as an invalid SQL expression I've also tried <#11/1/1958# but that just returns an empty set. -- God bless you, Keith Bates www.new-life.org.au If you don't have a reason to live JESUS IS THE ANSWER! Ask him into your life today... He really does make a difference
