Overflow

A

Alylia

I have a report of 162 records and 42 pages which whenever I try to export to
excel about at page 34 of and returns the message box with 'Overflow'.
However, I would like to point out that this is not so with other file
formats.

Please help.
 
D

Duane Hookom

There is probably a calculation that divides by 0 or something similar. Find
that record to confirm this and change the calculation in your query or
report to not divide by 0.
 
A

Alylia

Thanks for your response.

I have check to confirm that there is no calculation dividing anything by 0
whatsoever on the report or in the query on which it was created. The
calculation which I have are only count the number of records and the sum of
amounts on the report. This report is essentially to extract records on
travel of staff.
 
D

Duane Hookom

You need to figure out if the error is caused be a record or records vs the
quantity of records. What have you done to trouble-shoot this? I usually
pare down the records returned to determine at what point the problem
appears.
 
Top