Display As

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

Guest

I have a query that runs and divides two numbers to get a value. When the value is zero you get an error because you can't divide my zero. I would like to display in this case in my report or query the value as zero instead oh error. Any suggestion.
 
George Schneider said:
I have a query that runs and divides two numbers to get a value. When
Click to expand...
the value is zero you get an error because you can't divide my zero. I
would like to display in this case in my report or query the value as zero
instead oh error. Any suggestion.

IIf([SomeField]=0, 0, [SomeOtherField]/[SomeField])
 
You must log in or register to reply here.

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

Access #Error in calculated field 1
IIF Statement Numbers 1
Avoiding dividing by zero errors using nz 3
Cross tab query with averages? 4
Division by Zero Error 1
Convert annual data to monthly 8
Divide by zero error 3
Divide by the minimum non-zero number in a range of cells 21

Back
Top