Sum and Nz

I

Ilan

Hi,
I want to get a sum of a column, but if there is no data
in the column i would like to print out a zero. Now, i
understand that there is a built in function Nz in
Access, but could i use it in my report?

Thanks,
Ilan
 
M

Marshall Barton

Ilan said:
I want to get a sum of a column, but if there is no data
in the column i would like to print out a zero. Now, i
understand that there is a built in function Nz in
Access, but could i use it in my report?
Click to expand...


Sure, the expression would be:

=NZ(Sum(columnname))

Or, you can leave it as you have it and set the text box's
Format property to display 0 instead of nothing when the sum
is Null. For integer values the format could be as simple
as:
0;;;\0
 
Top