Why cant I do this!!

[HelenP]

Hello,

I have read through loads of forums about calculating totals in reports and have tried the =SUM() function but it only ever returns error.

What am I doing wrong?!

Thanks in advance

[NoellaG]

Hi helen,

hard to answer if we don't exactly know what you have done, and how your report/ data look like.

gr
NG

[HelenP]

I have three fields in the detail section:
CountOfPaymentRef
SumOfEntryAmount
SumOfOverallDebt

I want a total of each of these fields in the page footer

[NoellaG]

Hi,

try putting the sum expression in the report footer or groupsfooter.

gr
NG

[HelenP]

Still no joy

I have =sum([CountOfPaymentRef])

What am I missing?

[jgelpi16]

Forms always drive me crazy. I think you need to add a text box in the header (visible = no) that sums up the field, then add a field in the footer (visible = yes) that is based on that text box in the header. Play around with that. I have been able to get that to work for me. Does not make any sense, but works.

[HelenP]

Forms always drive me crazy. I think you need to add a text box in the header (visible = no) that sums up the field, then add a field in the footer (visible = yes) that is based on that text box in the header. Play around with that. I have been able to get that to work for me. Does not make any sense, but works.

I have tried this and now have the total coming up in the detail section after each record, but I cant link it to the textbox that I have put in the footer :S

[NoellaG]

Hi,

I never had to use tricks like jgel described, but I tried out the following demo to show the totals:

If it doesn't work, just try to make the report through a wizzard with the totals, you can always fine-tune the looks afterwards.

grNG