A missing value can lead to confusion by returning error values. But a properly used Nz() function can turn an error message into an understandable and expected value.