Null Values

[Michael]

Is there a way to take all the null values on a report
and change them to zeros? Thanks

Mike

 

[Roger Carlson]

In the query behind the report, use the NZ() function in every field that
needs it:

nField1: NZ(Field1,0)

 

[Michael]

ok, so i did this and it worked, but not i'm unable to
format the numbers and i want them as currency. any way
to do this?

Thanks!

 

[Roger Carlson]

Try this:
nField1: format(NZ(Field1,0),"Currency")

 

[Marshall Barton]

Is there a way to take all the null values on a report
and change them to zeros?

Another way is to use a custom format on the text box(es?)
in the report. See Format Property in Help for details, but
the general idea is that formats have four parts -
positive;negative;zero;Null so if your field a currency
value you might use something along the lines of:

$#,##0.00;;;"$0.00"
(if you leave out a part, it uses the first part)