View Full Version : Summing up sums


Geneo
07-04-2005, 11:43 AM
Hi and I´m not the best access programmer but I try.
I have summed up different fields in my report by useing =summe([fieldname]) and this works out great. Now it would be even nicer to be able to summ up the total of all summs.

How should my formula look like ??

Thanks
Geneo

ThreeCrow
07-04-2005, 11:56 AM
In the Report Footer place a CopyAndPaste of you Sum Textbox, this will Sum the whole column.

Rich
07-04-2005, 01:03 PM
=[Textbox1]+[Textbox2]+[Textbox3] etc, where the textboxes are the controls displaying your Summed fields

Geneo
07-04-2005, 01:08 PM
The reply that I recieved did not help very much but try and try again and sometimes you fiqure it out on your own.

This is the way it should look and it works just fine.

=Summe([Fieldname]+[Fieldname]+[Fieldname]+[Fieldname]+[Fieldname])


Hope someone else kann use this info.