Division by zero

E

Einari

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
 
K

Ken Snell [MVP]

Where are you using this expression? In a query? in VBA code? in the control
source of a textbox?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Division by Zero Error 1
Hiding a #Num! occurrence in a report output 4
Dividing by Zero in Access Reports 9
Need help removing extra TOC text from number lists used as TOC levels 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Expressions in Sub headers 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
MS Project. Real progress of the project, % complete 1

Top