Nz
Returns non null value.
Variants
Nz(value1, value2, …, valueN)
Returns first not null value.
Parameters
- value
- This function can take 2 or more parameters of any data type, as long as they are all the same type.
Returns
The result is the same data type as the parameters.
Examples
Nz([Delivery Date], [Shipment Date])returns the value in the "Delivery Date" column, if it exists. If there is no value in the "Delivery Date" column, this formula returns the value in the "Shipment Date" column.
Nz(text)
It returns x if x is not null. If it is null, it returns the next alternate value, if this value is not null.
Parameters
- text
- The text value to check.
Returns
Text
Examples
Nz("TEST")returns TEST value.Nz("")returns an empty string.Nz([Last Name])returns the text value from "Last Name" column if it exists oterwise return an emply string.