Dividing by zero

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

I have a number of calculated controls on a report. However some of the data
is not always available for the calculations and is therefore 0 which means
that I occasionally get the message Div/0! in the report. Can anyone suggest
anything that I can do to replace this error message with maybe "N/A"?
Thanks
Tony
 
See Help for information about the Nz function. You can use it to specify a
"value if null" number.
 
Back
Top