Runtime error 6: Overflow Error 1

[JasGrand]

Hello, I'm getting a runtime error 6: Overflow error on the following line of code:

ThisReportDepMin = IIf(Not (DepMinCount = 0), Format((DepMin) / (DepMinCount), "Fixed&quot, "0&quot

In this example, all of the above fields are equal to zero.
If there are numbers greater then 0 in these fields, the formula works. Any help is appreciated.

Thanks,

Jason Grandmaison

 

[JasGrand]

By the way, the error only occurs when the DepMinCount variable is equal to zero.

Thanks again,

Jason Grandmaison

 

[JeremyNYC]

An immediate if statement evaluates both parts of the statement (true and false) no matter which is correct. This means you're forcing it to divide by zero, which is giving you an overflow error. See what you can do to rebuild this in a way that doesn't force division by zero.

Jeremy ==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[JasGrand]

Hello, Thanks for answering. I already figured that out about the IIF statement so I reverted back to the standard IF THEN ELSE statement.

Thanks again,

Jason Grandmaison