Print 0 in field if no data

  • Thread starter Thread starter andy
  • Start date Start date
A

andy

I have a calculated field in a report. Could someone
please tell me how I can code that if there is no data
(isnull?) in that field for that record, that it will
print a zero. Please tell me where I should put the code,
in what attribute of the property of that field would it
go? or do use expression builder? How do I go about doing
this. If possible please give code and specifics.

Thank you in advance.
God bless you.
 
You can set the control source to:
=Nz([your expression],0)
make sure the name of the control is not also the name of a field.
 
Back
Top