default value

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

Guest

How do I default a zero in a field on a report?

The onlt thing is if the value in the query is higher than zero than I want
that not the zero.
 
Do you want negative numbers to appear as zeros, or do you want nulls
returned from the query to appear as zeros?
 
If you are saying you'd like a blank field to appear as "0" then you would
create a new unbound text box and use the Nz function to replace a null
value with a zero...

text box source would be...


=Nz ([SomeField],"0")
 
Rick,

Thanks, this worked. Now I ran into another issue. I have totals at the
bottom of the page based on the data in the queries. and now they don't
work.


Rick B said:
If you are saying you'd like a blank field to appear as "0" then you would
create a new unbound text box and use the Nz function to replace a null
value with a zero...

text box source would be...


=Nz ([SomeField],"0")



Quentin Stringham said:
Do you want negative numbers to appear as zeros, or do you want nulls
returned from the query to appear as zeros?
Click to expand...
Click to expand...
 
You would need to leave the original field on the report if you are
calculating based on it. Just make it invisible.

Joseph said:
Rick,

Thanks, this worked. Now I ran into another issue. I have totals at the
bottom of the page based on the data in the queries. and now they don't
work.


Rick B said:
If you are saying you'd like a blank field to appear as "0" then you would
create a new unbound text box and use the Nz function to replace a null
value with a zero...

text box source would be...


=Nz ([SomeField],"0")



Quentin Stringham said:
Do you want negative numbers to appear as zeros, or do you want nulls
returned from the query to appear as zeros?

How do I default a zero in a field on a report?

The onlt thing is if the value in the query is higher than zero than I
want
that not the zero.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top