Divide by 0 (1 Viewer)

[Toff]

I know, I know, you cannot divide by 0. Its ok if you rolled your eyes at the title.

I have this:

Me![Mar_8] = IIf(Me![Mar_1] = 0, Null, Me![Mar_7] / Me![Mar_1])

It is still giving me a divide by 0 error.

Mar_1 is indeed 0 but it seems to be skipping the Null and still trying to do the division.

I'm sure I'm missing something easy ....

Could the Mar_1 field being set to Currency be confusing it?

 

[Toff]

Since the error only occurs by looking at previous years data then switching to current year, I decided to just Null out the offending fields prior to Calculating which my error code handles. Still have no idea why my IIf didn't want to work.

 

[namliam]

IIF always and I do mean ALWAYS calculates both parts of the statement no matter if the result should be shown or not.

IT is a pain, but its the way it is

 

[Brianwarnock]

So to complete this, the only way is to use If..Then...Else

 

[Toff]

Doh, well I got around it another way.

Thanks all.