Using the Null Keyword

You can use the null keyword to search for records that contain blank fields with null values. In form fields, a null value appears as an empty field in which no value has been specified.

You can use the null keyword in:

Filter-in-Place mode
Query form searches
Saved filters

The null keyword cannot be used for searches of field values in a collection (Edit > Find Value in Collection).

To do a null keyword search:

In Filter-in-Place mode, enter null in any field in which you can type characters.
In query forms, you can use the null keyword in any of the primary criteria or additional criteria fields that use the = (equal) or <> (not equal) operator.

NOTES:

To find records where a particular field is not blank (null), enter <>null
The null keyword is not case-sensitive. This means that it does not matter whether you enter it in all lower-case letters, all upper-case letters, or any combination of both lower- and upper-case letters.
To perform a search in which a field might contain, in whole or in part, the word "null," enclose it in asterisks (*null*).

Using the Null Keyword

Related Topics