Is null

[Adam]

Hi

I'm having a problem with the "Is null" criteria in one of my queries. My
query shows that there are 420 records with "is null" in the copies column.
However in the corresponding table there are 467 records that have a blank
entry in the copies column. Where am I going wrong?

Thanks again!
Adam

 

[Darren Bartrup]

Are you sure they're all Null?
Some of the records could contain an empty field (""), or a space character
(" ").

http://www.databasedev.co.uk/null_values_defined.html

 

[John Spencer]

Probably the additional records have a zero length string instead of a
null. Try changing the criteria to

IS Null Or = ""

Or add a zero-length string to the field and then check to see if the
field is equal to ""

Field: Test: Somefield & ""
Criteria: = ""

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================