Hiding Zero

  • Thread starter Thread starter DavidW
  • Start date Start date
D

DavidW

I had nulls in my report and as far as the report it did fine, up until you
sum your totals, when there were nulls , my sums returned an error.
So I went back and changed my entries to zeros and the sum function works
fine

How do you get around having both worlds at the same time.
I dont like zeros in reports
I do like nulls in my forms

What should I do?
 
DavidW said:
I had nulls in my report and as far as the report it did fine, up until you
sum your totals, when there were nulls , my sums returned an error.
So I went back and changed my entries to zeros and the sum function works
fine

How do you get around having both worlds at the same time.
I dont like zeros in reports
I do like nulls in my forms
Click to expand...


Leave the Nulls alone, they have a different meaning than a
zero does.

Sum (and the othe other aggregate functions) ignore Null,
and, in my experience, return Null if all the records have
Null in the field that you're summing. I guess I'm saying
that I don't understand how you can get it to work with
zeros, but not with Nulls, so I'm led to believe there is
more going on that what you've explained above.

If worse comes to worse, I suppose you could get around the
issue by using:
=Sum(Nz(somefield, 0))
 
Back
Top