Aggregate Functions
-
Date Functions
-
Math Functions
-
Text Functions
-
Window Functions
-
IsNull
Returns True if the argument is Null (does not contain valid data), and False otherwise.
Usage
IsNull(<argument>)
argument (required) Any argument can be provided. The function can analyze one argument at a time. IsNull is often applied to column of data to test for Null values.
Examples
IsNull([Sales])
- Function will return False for rows where sales data exists and True for rows where there is no data.
More About
Logical Functions
Logical functions test for True/False values. They evaluate a condition, and return a value based on whether the condition is True or False.
