help... "overflow" error...

[Brook]

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

 

[SA]

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.

 

[Brook]

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

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

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