Overflow

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
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.
 
Back
Top