Overflow Error while Exporting access reports to excel file

[Swapnil Vaidya]

Hi All,
I have got stucked up in one problem from many days.
I have one report in Access 97. When I do right click on it and select option "Save As./Export". It gives me Error as "Overflow".. Actually I am very new to Access. So please help me.

[Denburt]

I'm not sure this will help but It sounds like you are trying to export the report while it is closed, try opening the report then export it. Let me know if this helps.

[Swapnil Vaidya]

I'm not sure this will help but It sounds like you are trying to export the report while it is closed, try opening the report then export it. Let me know if this helps.

Thanks a lot for your quick response.
Actually I opened it and then tried to export it..It gives the same error.
Can you advice?

[JKing]

If you're using calculated fields on your report ensure that no nulls are being passed through that would disrupt those calculations.

[Denburt]

JK is right for the null values as well as any fields that may contain errors, remember that there can be hidden fields only viewable in in design view etc. Is this a report that you designed or have you taken it over from some other designer? I was also wondering what you might be trying to export it to? I have witnessed many issues in exporting due to the fact that a field may contain numbers and text. The field may be a text field but when MS Access sees the numbers it doesn't matter numbers it is so it will error out and not export.

[Vekleth]

I have a similar issue, however, 2 users are getting the overflow error on a particular report, yet when I export the report I don't get the overflow error.

Any ideas?

[Denburt]

I have a similar issue, however, 2 users are getting the overflow error on a particular report, yet when I export the report I don't get the overflow error.

Any ideas?

It can be hard to say without more info, there can always be so many variables in these situations. I have witnessed incidents where a particular P.C. may not have enough resources. I closed a few apps and sometimes that helps. Sometimes the P.C. with problems just doesn't have what it takes either.