help... "overflow" error...

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

Guest

good day all..

I have a report that I am creating that has my company's cost and profits.

this report is based on a qrycost/profit that I have several calculations.
On my report I am trying to create report totals, for the calculations from
my query.

I have been successful in added 3 totals, but then when I try to add the
4th and 5th totals I get the overflow error.

However, when I add my totals to my report, I get an overflow error when I
try to "run" or open the report.+

Successuful :
=Sum([TotalPrice])
=Sum([totalM2Price])
=Sum([strikeofffee])
=Sum([TotalRugProductionCost])

Unsuccessful:
=Sum([TotalRugCostProdUSEntry])
=Sum([TotalProfit])

Any ideas / suggestions?

Thanks,

Brook
 
Brook:

Look at values in your fields TotalRugCostProdUSEntry and TotalProfit. Sum
works on number values. If you have string values returned for these (i.e.
your query shows the values as left justified in the query grid) or null
values, that may be the source of your error.
 
Good Day SA,

Thanks for the response,

I think the issue is going to be with null values, should I have something
set up so that if Null then zero? or something of the sort?

Brook

SA said:
Brook:

Look at values in your fields TotalRugCostProdUSEntry and TotalProfit. Sum
works on number values. If you have string values returned for these (i.e.
your query shows the values as left justified in the query grid) or null
values, that may be the source of your error.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

Brook said:
good day all..

I have a report that I am creating that has my company's cost and
profits.

this report is based on a qrycost/profit that I have several
calculations.
On my report I am trying to create report totals, for the calculations
from
my query.

I have been successful in added 3 totals, but then when I try to add the
4th and 5th totals I get the overflow error.

However, when I add my totals to my report, I get an overflow error when
I
try to "run" or open the report.+

Successuful :
=Sum([TotalPrice])
=Sum([totalM2Price])
=Sum([strikeofffee])
=Sum([TotalRugProductionCost])

Unsuccessful:
=Sum([TotalRugCostProdUSEntry])
=Sum([TotalProfit])

Any ideas / suggestions?

Thanks,

Brook
Click to expand...
Click to expand...
 
Back
Top