Field not empty

[Robin Chapple]

I have a membership database where the date of leaving is recorded.

If I take a query and as for all records where that field Is Not Null
I lose one record.

Visual inspection sees and empty field. I have used delete and back
space in the field but it is still missing from the query result.

Is there something that I have missed?

One possibility that occurs is to enter " must be a date field" in the
criteria but don't know how to do that.

Thanks,

Robin Chapple

 

[B. Comrie]

If it Is Not Null then it should have data in it, so an empty field will not
show up. If you want it to show up you need a "date of leaving" in it.

Is the datatype set to DateTime?

B Comrie
http://www.codewidgets.com

 

[Robin Chapple]

Sorry,

I've got the wrong teeth in my mouth.

The query asks for all records where the field "Is Null". The field
records the date of leaving and therefore active members should have a
blank field.

I get one record left behind.

My apology.

Robin Chapple