Overflow

[Ofer]

I have a report that I print out once a month. When I last
tried to print the report for May 2004, I received an
error saying "Overflow". It worked perfectly fine for
other months. Can it be that there is just too much data
for May? overflow of what? how can I over come this
problem?

Thanks!!

 

[SA]

Ofer:

Overflow generally comes from either of the two following problems:

1.) You have a divide by zero problem in the report's underlying query or in
a calculation on the report. To resolve always test for zero when dividing
as in:

IIF([DenominatorField] = 0 or IsNull([DenominatorField]), 0,
[NumeratorField]/[DenominatorField])

2.) You are using VBA in your report and you are assigning a value to a
variable that is to large for the variable. e.g. assigning 100,000 to an
integer variable which is limited to 32,767

90% of the time however the issue is #1

 

[Guest]

Thank you!!! the devide by zero was the problem!!
THNAKS!!

-----Original Message-----
Ofer:

Overflow generally comes from either of the two following problems:

1.) You have a divide by zero problem in the report's underlying query or in
a calculation on the report. To resolve always test for zero when dividing
as in:

IIF([DenominatorField] = 0 or IsNull([DenominatorField]), 0,
[NumeratorField]/[DenominatorField])

2.) You are using VBA in your report and you are assigning a value to a
variable that is to large for the variable. e.g. assigning 100,000 to an
integer variable which is limited to 32,767

90% of the time however the issue is #1

--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

I have a report that I print out once a month. When I last
tried to print the report for May 2004, I received an
error saying "Overflow". It worked perfectly fine for
other months. Can it be that there is just too much data
for May? overflow of what? how can I over come this
problem?

Thanks!!

.