How to use Nz or Null to Zero Function in MS Access - Office 365

A null value represents the absence of any value. When you see a data item in MS Access table that is empty or has no value is considered null. If MS Access encounters a null value in a numeric field any calculation involving that field is null. You can avoid null calculation errors by using Nz or Null to Zero function. This video explains in detail the arguments of Nz function and how to use this function to avoid null calculation errors.

Category