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.

Don't let Null values derail your ... Now when you run the query, orders without shipping charges will show an Invoice total: Check out the Microsoft Access archive and catch up on other Access ...