Help.. Can anyone help? My report has 5 columns A b c d. There i a querey that drives each column. I built a formula that will sum a b c d. However column c is blank. I am getting no data in the total column. This only happens when one of the fields has no value.

Use the NZ function (to handle nulls - nulls added to a value always returns a null):

Nz([Field1],0)+Nz([Field2],0)...etc.

Thank!!! I will try it