Hiding and Showing Zeroes in Reports

  • Thread starter Thread starter Janet Friesen
  • Start date Start date
J

Janet Friesen

Hello,

I have a report where my calculation isn't working
because one of the fields I'm trying to add sometimes
doesn't have any value in it. How do I show a zero if
there is no number in that field?

Also, how do I show blanks in place of zeroes in a report?

Thanks!
Janet Friesen
 
From Microsoft help file
You can use the Nz function to return zero, a zero-length
string (" "), or another specified value when a Variant is
Null. For example, you can use this function to convert a
Null value to another value and prevent it from propagating
through an expression.
Syntax
Nz(variant[, valueifnull])

Jim
 
Back
Top