I would like to create a calculated field in a table, which sums the values of several other fields. If I use the formula Total = [FieldA]+[FieldB]+[FieldC]+[FieldD], I will get a value only if there is an entry for each field. What I want to get is a total even if one of the fields has no value entered. I've considered setting a field default value to "0" for the fields in the equation, but that could be misleading because some of the fields may actually have a value of Zero although others are intentionally left blank. Previously I did the calculation in queries and used "nz" prefix to allow the formula to work with null values. That doesn't function in a table calculation.
How can I sum values to create a calculated field in a table when one or more of the cells used in the calculation is actually a null value (no entry) rather than Zero?