How do I suppress all zeros from appearing in a field in a report.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For example in a roport I am print sales history by Month. If a month sales
is zero I do not what zeroes to print out. I want the field to be blank or
print out spaces. (In cobol we used the format type ZZZZ.ZZ)
Thanks
 
Mr S,
Check out formatting in Help.
A format like this has 4 parts seperated by ";s"...
#.0;-#.0;"";""
This would display Positive numbers with 1 decimal place,
negative numbers with a minus sign and 1 decimal place,
0's as blank, and Nulls as blanks.
hth
Al Camp
 
Back
Top