Danielle:
There are three primary causes for an Overflow error. You need to look at
your query results to see which might apply.
1.) If there is a divide by zero error in the query. To solve, use an IIF
statement e.g. IIF(Field1<>0, Field2/Field1, 0)
2.) If you have values in the field you are trying to sum that may be
producing either #Error, or a null value, or if you are trying to sum values
that are really text values returned by your query, (i.e. text values will
be left justified in the query, actual numbers will be right justified.
3.) If you have any VB Calculations in your report where you are trying to
assign a value to a variable that is too small, i.e. assigning a number like
200,000 to an integer variable.
HTH
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg
Danielle said:
Trying to create a report using the Query table. REport produces an error
when trying to "sum" the fields that were calculated in the query... What
should I do?
