supress zero

S

Souris

Are there any way to supress zero in the report when query return zero in the
value?



Your information is great appreciated,
 
M

Marshall Barton

Souris said:
Are there any way to supress zero in the report when query return zero in the
value?
Click to expand...


You can use a custom format in the text box where you do
not want to see the 0s. It depends on how you are
formatting the values that are not zero though. E.g. If
the values are displayed with the Currency format, then your
custom format could be:
$#,##0.00;($#,##0.00);"";""
If the values are simple integers, the format could be:
0;;"";""
 
Top