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