Report Error: Overflow

[Robbro]

Got my report laid out and I'm sure its very suboptimal, but as long as I can
get my printouts I'm ok with that. Problem is now I can open the report in
design view but trying to go to layout or report view, i just get an
"Overflow" error and kicked back to design view. Its been getting sluggish
so I may be asking too much of it, I dont really know. I've went back and
deleted my last few boxes and calculations in design view to see if those
were the sole cause but I still cant get into other views without the error.
Does this error point to a possible easy fix or should I scrap my report
plans?
I have 3 tables and 1 query feeding into a summary query which feeds my
report, I have all the calculations I can performed in the summary query
(found it difficult or impossible to use calculated #'s in the report in
other calculated #'s). The report does calculate per customer summary
information too though.

 

[John Spencer]

Probably, you have a data type that is too small to hold the summary.

For instance, an integer field is limited to plus or minus 32K (roughly). If
you are summing a lot of records it is very easy to exceed that. Try changing
the number type of your fields to LONG integer (for integer types) and
Double for Single types.

If you can't do that you can use the conversion functions in your query to
force a conversion. You would need to use something like the following
SUM(CDbl(Nz([YourFIeld],0))

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County