Access VBA error "Overflow" (1 Viewer)

daryll · Jan 14, 2018

Hi!

Why this code still throws an overflow error

Code:

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

daryll · Jan 14, 2018

Thanks! I got it!

NauticalGent · Jan 14, 2018

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 · Jan 14, 2018

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 · Jan 14, 2018

NauticalGent said:
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_ · Jan 14, 2018

Let me guess, your solution was

Code:

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 · Jan 18, 2018

Mark_ said:
Let me guess, your solution was

Code:

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

Code:

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

plog · Jan 18, 2018

No need to test cbSTartNotStarted at all:

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

Access VBA error "Overflow" (1 Viewer)

daryll

Registered User.

daryll

Registered User.

NauticalGent

Ignore List Poster Boy

NauticalGent

Ignore List Poster Boy

daryll

Registered User.

Mark_

Longboard on the internet

daryll

Registered User.

plog

Banishment Pending

Similar threads

Users who are viewing this thread