How to use NZ () to display null values as 0 in access?
Nz is a function that makes null values zero. Seeing the above statement makes me dizzy, so I don't look closely.
This function is generally used in expressions, and the format is =Nz (expression). If the expression calculation result is empty, assign 0; otherwise, it is the result of the original expression.