Inconsistent operations

[Guest]

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?

 

[SusanV]

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

 

[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.

 

[Guest]

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