What Does Nz Mean in Access
You Can Use the Nz Function to Return Zero (0), a Zero-Length String (“”), or Another Specified Value When a Variant Is Null. for Example, You Can Use This...
You can use the Nz function to return zero (0), a zero-length string (“”), or another specified value when a Variant is Null. For example, you can use this function to convert a Null value to another value and prevent it from propagating through an expression.
What does NZ stand for in Access?
Description. The Microsoft Access Nz function lets you return a value when a variant is null.
What is a null value in Access?
A null value indicates that the data is missing or unknown. Occasionally, a null value does mean that the data doesn’t exist or isn’t valid for that particular record, but the concepts aren’t interchangeable.