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 -- 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
