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.