Summing up sums

Geneo

Registered User.
Local time
Today, 00:06
Joined
Dec 31, 2002
Messages
11
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
 
In the Report Footer place a CopyAndPaste of you Sum Textbox, this will Sum the whole column.
 
=[Textbox1]+[Textbox2]+[Textbox3] etc, where the textboxes are the controls displaying your Summed fields
 
Results are as...

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.
 

Users who are viewing this thread

Back
Top Bottom