=sum().. error??

  • Thread starter Thread starter marco_pb via AccessMonster.com
  • Start date Start date
M

marco_pb via AccessMonster.com

Hi.. I'm really sorry if this has been discused before in this forum
I have a problem with =Sum() function

I put it in footer, and it works when I have only a few of data.. when I have
lots of data with different number (shown in example), it give me error like
this:
data: | result:
total cost: | total cost:
======== | ========
12 | 11
11 | total= 11
12 | 12
15 | 12
| total= 24
| 15
| total= 15

what i want is
total cost:
========
12
11
12
15
total= 50

can anybody help??

thank you very much..
 
marco_pb via AccessMonster.com said:
Hi.. I'm really sorry if this has been discused before in this forum
I have a problem with =Sum() function

Don't put it in the section footer, put it in the Report Footer.

Tom Lake
 
thanks to all before...
I have mistakenly do a grouping...
I grouped it by the cost.. now I have teh answer..

thank you all...
 
Back
Top