Eliminate zeros in queries

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I am using Nz function in a calculated field of a query.
Is there any way to make the zeros not show up in the
report created from the query?

Ex: BundCost:Nz([Fieldname],0)*[fieldname]

Thanks for any help
 
You can set the Format property to display "" when the value is 0. Check
help on the format property for numeric values.
 
-----Original Message-----
You can set the Format property to display "" when the value is 0. Check
help on the format property for numeric values.

--
Duane Hookom
MS Access MVP


Dave said:
I am using Nz function in a calculated field of a query.
Is there any way to make the zeros not show up in the
report created from the query?

Ex: BundCost:Nz([Fieldname],0)*[fieldname]

Thanks for any help
Click to expand...


.
I have looked all over the format for a way to do this.
Click to expand...
Can you give me an example, please.
 
The format property can specify 4 different formats based on if a number is
1) Positive, 2) Negative, 3) Zero, or 4) Null. Set the format like
0.00;-0.00;"";""
The Positive and Negative formats may need to be modified to meet your
needs.

--
Duane Hookom
MS Access MVP


Dave said:
-----Original Message-----
You can set the Format property to display "" when the value is 0. Check
help on the format property for numeric values.

--
Duane Hookom
MS Access MVP


Dave said:
I am using Nz function in a calculated field of a query.
Is there any way to make the zeros not show up in the
report created from the query?

Ex: BundCost:Nz([Fieldname],0)*[fieldname]

Thanks for any help
Click to expand...


.
I have looked all over the format for a way to do this.
Click to expand...
Can you give me an example, please.
Click to expand...
 
Back
Top