Display As

G

George Schneider

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.
 
R

Rick Brandt

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])
 
Top