I want to show a 0 in a report field based on a query

  • Thread starter Thread starter Guest
  • Start date Start date
No idea what you are asking for.

Please give us some details and examples.

If a field is the result of a query, why would you place zero in it?
 
Leslie said:
I want to have a 0 (zero) placed in a field that is a result of a query
Click to expand...


If you always want the query to have a zero instead of a
field feom a table, just use 0 instead of the field name.

If you only want to display a zero when the query returns a
Null for a field's value, then set the form's text box's
Format property to a custom format. Without knowing what
the field would normally have in it, I can only provide an
example:
#,##0.00;(#,##0.00);0.00;"0.00"
See Format property in Help for other options.
 
Back
Top