M
Michael
Is there a way to take all the null values on a report
and change them to zeros? Thanks
Mike
and change them to zeros? Thanks
Mike
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Roger Carlson
In the query behind the report, use the NZ() function in every field that
needs it:
nField1: NZ(Field1,0)
needs it:
nField1: NZ(Field1,0)
M
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!
format the numbers and i want them as currency. any way
to do this?
Thanks!
R
Roger Carlson
Try this:
nField1: format(NZ(Field1,0),"Currency")
nField1: format(NZ(Field1,0),"Currency")
M
Marshall Barton
Michael said: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)