J
JimP
One way to do this is to set the format to "#,###.00;-#,###.00;[White]".
Is there a better,or more conventional, way?
Is there a better,or more conventional, way?
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.
V
vanderghast
If that is the only information, you can remove the record with a WHERE
clause, but that eliminates the whole record, that is why this is only
applicable if this field is the only information to be printed in the 'row':
WHERE fieldname <> 0
Vanderghast, Access MVP
clause, but that eliminates the whole record, that is why this is only
applicable if this field is the only information to be printed in the 'row':
WHERE fieldname <> 0
Vanderghast, Access MVP
J
John Spencer
Try using the format
#,###.00;-#,###.00;"";""
This assumes you want the record to print, you just don't want to see the
value zero displayed by one control.
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
#,###.00;-#,###.00;"";""
This assumes you want the record to print, you just don't want to see the
value zero displayed by one control.
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
J
JH
I take it the field is numeric?
When you say suppress, do you mean you don't want zero to show up at all?
or you just want it to be 0.00 (as it appears you are trying to do with your
formatting).
If you just want to suppress it entirely, you can always change the query
that serves as the report recordsource.
find the field that returns the zero (let's call it FieldA) and change it to:
iif(FieldA=0,"",FieldA) As NewFieldA
if you go this route, you'll have to change the data source for the field on
your report (it used to be FieldA, it now would be NewFieldA).
When you say suppress, do you mean you don't want zero to show up at all?
or you just want it to be 0.00 (as it appears you are trying to do with your
formatting).
If you just want to suppress it entirely, you can always change the query
that serves as the report recordsource.
find the field that returns the zero (let's call it FieldA) and change it to:
iif(FieldA=0,"",FieldA) As NewFieldA
if you go this route, you'll have to change the data source for the field on
your report (it used to be FieldA, it now would be NewFieldA).
J
JimP
Thank you,
This is a numeric field, and I don't want "0's" to show up on the report in
columns where they appear. This solution will work fine.
This is a numeric field, and I don't want "0's" to show up on the report in
columns where they appear. This solution will work fine.
John Spencer said:Try using the format
#,###.00;-#,###.00;"";""
This assumes you want the record to print, you just don't want to see the
value zero displayed by one control.
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
One way to do this is to set the format to "#,###.00;-#,###.00;[White]".
Is there a better,or more conventional, way?