Current location - Health Preservation Learning Network - Healthy weight loss - How to use NZ () to display null values as 0 in access?
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.