On Mon, 2009-06-01 at 21:51 +0200, Franz Wein wrote: > Hi Keith > > This is a problem in nearly all database - systems - my solution - use a > date of death for all your fishes for example the 31.12.2999 - normaly > this date ist possilbe in all database. If a fish died - fill in the day > of death! > > Franz
Thanks Franz. Trouble is I'm too lazy to remember to do that. I suppose I could set that up as a default in the data entry form. Anyway Drew's response of "IS EMPTY" in the query works. Keith > > Keith Bates schrieb: > > 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 > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > -- 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
