Fortunately, the NZ function converts Null values to zeroes so they are included in a calculation. Follow these steps: Open the query in design view. Delete the Invoice_Total formula.

Null means "undefined" in SQL, so numerous online services don't think Christopher Null exists. ... "Allowing NULL values makes you work extra hard to get the kind of data you are looking for.