Inconsistent operations

  • Thread starter bracknellconfused
  • Start date
B

bracknellconfused

I have a database table of 177 records. Using an expression in a query of
Field<>"" correctly selects the 102 records that have values in Field.
However, another query using the expression Field="" does not select the
other 75 fields, in fact the query produces no results.

This is a nonsense in that if the <> result is being presented correctly the
= result should also operate and deliver the other records to a query.

Any suggestions, is there a bugfix missing?
 
S

SusanV

Try using Field Is Not Null and Field Is Null as criteria rather than the
empty string
 
V

Van T. Dinh

You have some Null values in this Field. The problem is neither Boolean
expressions:

[Field] = ""

or

[Field] <> ""

will return True if the [Field] is Null

Try the criterion:

[Field] Is Null

and the Query will return the missing rows / Records.
 
O

Ofer

You can use the filter on both criteria
Where FieldName Is Not Null and FieldName <> ""

Some of the field can be empty and some can be null
 
Top