Null field problem =Sum(Nz([Sale Price],0))

[fredhayes]

A newby is stumped.

Attached is a screen shot of a report I am trying to build.

I placed =Sum(Nz([Sale Price],0)) in Control Source but I am getting a blank when it should be a "0" in a number of fields.

Any help I can get with this will greatly appreciated.

 

[NickHa]

Does every column shown have a formula? It looks like the left-hand columns are simply showing null fields as blank? Is there a specific column to which your question relates, or is it all of them?

 

[fredhayes]

It applies to all columns which are sub reports

It is returning a blank field instead of a "0" on days when there was no activity in that chart of accounts catagory for that particular day.

 

[fredhayes]

One more thing.

A "0" is shown in fields in which an item was sold having no cost.

 

[RainLover]

I would handle this in the Query using TOTALS.