I have a number field that is displayed on a report. There are times when there will be no value stored in the field. When this is the case, I want to display a text message instead of leaving it blank. I use this field for calculations so I cannot change it to a text field. Is there a way to do this? I was playing with the following formula, but get the error message ' #ERROR '
=(IIF([Volume] Is Null,"Data Not Available",[Volume]))
=(IIF([Volume] Is Null,"Data Not Available",[Volume]))