Access 97

  • Thread starter Thread starter The O'Brien Family
  • Start date Start date
T

The O'Brien Family

I know that I must use numeric fields in a table to do calculations. I
do not, however, wish to display 0 in the reports that I generate. Can
anyone tell me how I can suppress the 0's in my reports?
Thanks.
 
The O'Brien Family said:
I know that I must use numeric fields in a table to do calculations. I
do not, however, wish to display 0 in the reports that I generate. Can
anyone tell me how I can suppress the 0's in my reports?
Thanks.
Click to expand...
Set the control source for the text box displaying your [number] to:

=iif([number]=0,"",[number])

David
 
The O'Brien Family said:
I know that I must use numeric fields in a table to do calculations. I
do not, however, wish to display 0 in the reports that I generate. Can
anyone tell me how I can suppress the 0's in my reports?
Thanks.
Click to expand...

David's suggestion is one way; another is a bit obscure but sometimes useful. The Format property of a numeric field can contain up to FOUR different formats, for positive, negative, zero and NULL values respectively. So you could set the Format property of the report textbox to

#;-#;"";"<NULL>"

to show zero as a blank empty string, and undefined values as the string <NULL>.
 
Back
Top