Access VBA error "Overflow"

[daryll]

Hi!

Why this code still throws an overflow error

IIf( (cbStatNotStarted=0 Or cbStatTotal=0), 0, (cbStatNotStarted / cbStatTotal) * 100 )

 

[daryll]

Thanks! I got it!

 

[NauticalGent]

I suspect it has something to do with the numbers themselves. Can you provide an example of what kind of values are in the equation.

Also, you should always check for null and Zero values, especially if you are doing division.

 

[NauticalGent]

Apologies, forget about what I said regarding checking for Zero, I can see now that you have.

I tend to go off half-cocked...

 

[daryll]

Apologies, forget about what I said regarding checking for Zero, I can see now that you have.

I tend to go off half-cocked...

Thanks for dropping in.

 

[Mark_]

Let me guess, your solution was

IIf( (nz(cbStatNotStarted,0)=0 Or nz(cbStatTotal,0)=0), 0, (cbStatNotStarted / cbStatTotal) * 100 )

so you could check for either zero OR null all in one fell swoop?

 

[daryll]

Let me guess, your solution was

IIf( (nz(cbStatNotStarted,0)=0 Or nz(cbStatTotal,0)=0), 0, (cbStatNotStarted / cbStatTotal) * 100 )

so you could check for either zero OR null all in one fell swoop?

This is the version I have

(IIf(cbStatNotStarted = 0, 0, cbStatNotStarted) / IIf(cbStatTotal = 0, 1, cbStatTotal)) * 100

 

[plog]

No need to test cbSTartNotStarted at all:


For all x<>0, 0/x = 0