Have a textbox in a re****t footer that sums data using Sum. That text box
value is used in a few calculations in the footer.
Trouble is, if the re****t has no data then the box simply shows #error and
all following calculations fail. Nz doesn't work.
In this case it is still valid for the re****t to show calculated values in
the footer even though the re****t actually contains no data. Values used
come from other places than the re****t data.
Is there anyway to get that text box with the Sum statement to show 0
rather
than #error?
Jeff
