Adding numeric values in Design View of Query

[velcrowe]

I am adding fields with numeric values in design view of my query. The only issue I am having is that the query is not showing totals when one of the fields does not have a numeric value in it. How can I show the total numeric value regardless of the null value? Thank you

 

[KenHigg]

Use nz(myval) instead of just myval in the column header.