Query for No Value in Field

  • Thread starter Thread starter David S. Calef
  • Start date Start date
D

David S. Calef

I am trying to create a query that finds ONLY missing values:

Nothing in a text field
or
No Value in a number field
or
No Value in a second number field.

I would assume the first criteria would be =""

The second and third Or Criteria would be =0

None of these are working for me.

Suggestions?

David
 
If a field contains no entry in a record, we refer to it as Null.

The criteria is therefore:
Is Null

In Text type fields (and Memo and Hyperlink), it is also possible that the
field contains a zero-length string, which is a different value than Null.
You may therefore need criteria:
Is Null OR = ""

So, you may end up with a WHERE clause that looks like this:
WHERE ([MyNumberField] Is Null) OR ([MyTextField] Is Null) OR ([MyTextField
= "") OR ...

If you are not used to working with nulls, there are several quite important
things to learn. There's half a dozen in this link
http://members.iinet.net.au/~allenbrowne/casu-12.html
 
Back
Top