An overflow error means the data type that Access is using is not large
enough to hold the result. To see an example, open the Immediate Window
(Ctrl+G), and enter:
? 200 * 200
You get the overflow error, because the code window treats the value of 200
as an integer, but the result is to large for an integer (i.e. greater than
32767.) To solve the issue, typecast one of the values to a long:
? CLng(200) * 200
Now to track down what's causing this error. The overflow could be occuring
with your data, or it could be within Access itself.
If this report is based on a query, run the query itself? Does it generate
an overflow?
If so, identify the calculated fields, and typecast them. Details:
http://allenbrowne.com/ser-45.html
If the calculated query fields call a user-defined function, the function
could be causing the overflow. Temporarily comment out any error handler in
the function, so you can see what line generates the error. Also, from the
code window choose Options on the Tools menu. On the General tab, make sure
Error Trapping is set to:
Break on Unhandled Errors
so you can see the errors. Also uncheck Compile on Demand (which can corrupt
the database.)
If the query runs fine, does the report have any code in its module? If so,
again comment out any error handler so you can see what is triggering the
error.
Next, identify the calculated controls on the report, e.g. those that have a
Control Source like this:
=Sum([SomeFieldOrOther])
Is there anything here that could overflow?
If necessary, make a backup copy of the databse, and start eliminating these
calculated controls from the report, until you identify which one is causing
the error. If there are heaps, eliminate half at a time; keep halving until
you pin down the culprit(s).
If none of that works, and particularly if this problem occurs in other
cases also (e.g. whenever you try this wizard), there could be a problem
with the installation wizard or some component the wizard is using. Here's
Microsoft's suggestions for tracking down these problems:
http://support.microsoft.com/kb/303769
http://support.microsoft.com/kb/242218