I am getting a "Overflow" error message when trying to run a report

[KingOf206]

Hello, So I have a report in which I made in a "test database" so that I could then import it into the "live database" Both databases are exactly the same, I just use the "test db" to try new things before I import them into the "live db."




My question is that I have made a new report, this report is doing some calculations such as Min, max, avg., & sum.

I am unable to run the report in the "live db" because I am getting the "Overflow" error message.

What am I doing wrong and how can I fix this?

Is there anything I can post to help show what I am doing?

[pbaldy]

One possibility is a divide by zero error. Another, if there is code, that a value in the data is too large for a variable.

[orange]

Here is a relevant response posted by Marshall Barton on a different forum.

An overflow error is when a calculation results in a number thatis too big to be stored in a field or variable. For example an Integer field can not store a value greater then 64K, so you will get an over flow when you multiply two numbers (eg. 12345 by 10000) that is greater than 64K. Another way to get an overfloe is by dividing a number by a really small value such as .00000001 and sometimes even 0.

You may be getting these errors because you are doing something (summing or multiplying?) some numbers that were ok before, but have increased to the point of overflow. Look at the expression that produces the error and see what the calculation does so you can figure out how it generates a large result, especially check for a divisor of 0.

Hope this is helpful.

[KingOf206]

If there some sort of code I can put in the report to account for "zero's" ? There will be zero's in some records but I still want to be able to run a report. How can I get past this?

[KingOf206]

Is there something I can post to show what it might by?

Also, all my data types in my tables have "long integers" and all my data is anywhere from 0-500 So I don't believe it could be data type is too large... could it?

[pbaldy]

One option

IIf(FieldName = 0, 0, CalculationHere)

[CJ_London]

So I don't believe it could be data type is too large... could it?

maybe, maybe not, without knowing what your calculations are and the types of values etc, all we can do is speculate - the overflow error is as described in the posts above.

with regards avoiding divide by zeros - the usual way is 'if value<>0 then anothervalue/value'

you also need to treat nulls - usually with the nz function or 'if value is not null' or 'if not isnull(value)

So you need to inspect your data

[KingOf206]

One option

IIf(FieldName = 0, 0, CalculationHere)

Where Would I put this code?

[pbaldy]

Wherever CalculationHere is.

[KingOf206]

I am unclear by what you are saying I should do. Should I place that code in my calculations field? If so what code?

maybe, maybe not, without knowing what your calculations are and the types of values etc, all we can do is speculate - the overflow error is as described in the posts above.

with regards avoiding divide by zeros - the usual way is 'if value<>0 then anothervalue/value'

you also need to treat nulls - usually with the nz function or 'if value is not null' or 'if not isnull(value)

So you need to inspect your data

[pbaldy]

Somewhere you have a calculation, let's say x/y. Replace that with IIf(y=0, 0, x/y)

[KingOf206]

ok, SO I have found THE calculation that is causing my "overflow" error... It is in the "report Footer" of my report and the calculation is "=Avg([Challenged])".

However, This field should not show 0 if there is division by 0. This field is being feed the data from other cells.

Here is a screen shot of my report (Everything works just fine UNTILL I add in the field "=Avg([Challenged])")



How can I make this so that is shows a true average, For example, the average of 0,0, & 10 should = 3.33 ([0+0+10]/3) but I am getting "overflow" error. How can I make this work to show a true average?

[KingOf206]

I tried this:

=IIf([Challenged]=0,0,Avg([Challenged]))[

But I still got the "overflow" error... what's going on?

QUOTE=pbaldy;285723]Somewhere you have a calculation, let's say x/y. Replace that with IIf(y=0, 0, x/y)[/QUOTE]

[KingOf206]

Any suggestions?

[CJ_London]

99.9% certain the problem is with your data. Try just a single record as your recordsource and see if that works. I presume you are not using multivalue or lookup fields? Not sure it would have an effect but are your controls named correctly?