Division by zero

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

Guest

Hi,
I'm creating a report that executes some divisions and sometimes there is
division by zero. I've tried avoiding problems using IIf ([products]=0; 0;
[hours]/[products]) but it only gives me error when there is zero.

Is there any better way doing this or is there something wrong with the way
I've tried to do it?

I'm using Access 2000
 
Where are you using this expression? In a query? in VBA code? in the control
source of a textbox?
 
Back
Top