Report Is Null, want Zero instead

[stevemccauley]

I have a report"A", that when opened, opens another report"B" and minimizes it. Report"A" then uses a textbox(from report"B") in a calculation. My problem is that sometimes report"B" is empty and the textbox with the total for my calc on report"A" shows an ERROR message. What can I do to have this textbox show a zero instead of ?Error?

Thanks,
Steve

 

[Chris66]

I am not sure I fully understand your problem but if I do, Can you run an Update query before you open report "A" to update the field in "B" which is blank with either the 0 or the letter "O". Hope that helps, if that was not your solution sorry to waste your time.

 

[Rich]

Please don't post under multiple topics

 

[mbentley]

=IIf(IsError([FieldName]),0,Sum([FieldName]))

Sometimes this works, too:

=IIf(IsNull([FieldName]),0,Sum([FieldName]))

Which one to use seems to depend on the underlying query structure, but don't ask me why.