Sums in Reports

jadair

Registered User.
Local time
Today, 23:16
Joined
Jun 13, 2003
Messages
17
I am trying to put together a report that will allow me to group records by division(not a problem), Then I have to calculate the total spent by each division. This is my problem. I cannot figure out how to add the sum formula into the report. ANy help is much appreciated.
 
In your grouping options, make sure that the group you want to sum has a footer. In that footer, add an unbound textbox with the controlsource set to =Sum([FieldtoSum])
 
I can never do this either so I use the report wizard to generate a report and then copy the bits out of it I need for my report. Would this work for you?
 
Grouping options

I dont get any grouping options that refer to footers. I tried to enter the code =Sum([COST]) into the main footer and i get an error?? Everything your are saying makes complete sense, i just cant find the grouping option that will allow me to edit the footer.
 
OK I got it

Sorry about that I was looking in the wrong place. It works perfectly now. Thnk you very much for all of your help. It is greatly appreciated
 

Users who are viewing this thread

Back
Top Bottom