default value

[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.

 

[Quentin Stringham]

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

 

[Rick B]

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")

 

[Guest]

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.

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")

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

 

[Rick B]

You would need to leave the original field on the report if you are
calculating based on it. Just make it invisible.

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.

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")

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.