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