Dividing by 0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I replace the #Div/0 with a blank for records that do not have values
yet for the high field?


Low / High

364.8/ 10327 = 0.035324877
364.8 / 0 = #DIV/0!
 
In the underlying query or in a calculation in the control's source? Basically,
you could use the expression

IIF(High = 0,Null,Low/High)
 
Back
Top