Sum of cells

  • Thread starter Thread starter T. Wintershoven
  • Start date Start date
T

T. Wintershoven

Hello,

In a form i have a subform in sheetview

One of the columns is named "totalprice" and the value is calculated with
values from 3 other cells.
So far ..so good

But.. when i want to sum up the values in the "totalprice" column the result
is always 0,00
If i fill in some numbers by hand in the "totalprice" cells, the result of
the sum calculation is correct.

So.. in short,

I can't do a SUM calculation with values whitch come from a calculation
themselfs, but it can be done when i replace the values with numbers filled
in by hand.

I've tried anything without success

Is there anyone who knows this problem and hopefully an answer.

T.i.a.
Regards

Tino Wintershoven
The Netherlands
 
Hello,

In a form i have a subform in sheetview

One of the columns is named "totalprice" and the value is
calculated with values from 3 other cells.
So far ..so good

But.. when i want to sum up the values in the "totalprice"
column the result is always 0,00
If i fill in some numbers by hand in the "totalprice" cells,
the result of the sum calculation is correct.

So.. in short,

I can't do a SUM calculation with values whitch come from a
calculation themselfs, but it can be done when i replace the
values with numbers filled in by hand.

I've tried anything without success

Is there anyone who knows this problem and hopefully an
answer.
Click to expand...
Replace the sum(totalprice) with sum(field1*field2+field3), or
whatever is the formula used to get each individual totalprice.

Bob Q
 
Bob,

Thanks for your reaction.

I found the reason why and solved it.

It was because the cells were not part of the query which the subform was
build from.

Tino
 
Back
Top