Display As

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

 

[Rick Brandt]

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.

IIf([SomeField]=0, 0, [SomeOtherField]/[SomeField])