Divide by 0 error

G

Gil Stone

Hi,

The following operation in a query, expenses/sells generates the following
msg: Divide by zero error encountered. I would imagine it's because some
fields have 0s (no expenses or sells). How do I get around it?

TIA

Gil



--------------------------------------------------------------------------------

Estoy utilizando la versión gratuita de SPAMfighter para usuarios privados.
Ha eliminado 1061 correos spam hasta la fecha.
Los abonados no tienen este mensaje en sus correos.
¡Pruebe SPAMfighter gratis ya!
 
V

Van T. Dinh

Can't see your operation but you can use an expression usng IIf like:

MyVal: IIf([DivisorField] = 0, Null, [DividendField]/[DivisorField])

to avoid division by zero.
 
Top