Add SQL’s Not operator to find values that aren’t Null. Using Northwind, the sample database that comes with Access, I will create a few queries to illustrate using Is Null and Is Not Null.

For example, if the NU option is specified for an ADABAS descriptor data field, null values for the data field are not stored in the inverted list. Therefore, a search using this data field and for ...