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
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
