Report Grouping and Calculating Subtotals then Total

  • Thread starter Thread starter Mia
  • Start date Start date
M

Mia

I am having an issue calculating subtotals in an Access Report. I have no
problem getting the total when I place the fields in the Report Footer, When
I try and place the same fields in the DivisionalTotalFooter, it is totaling
each entry not grouping the data together by Division. There are 6 division
categories and I would like to show on the report each entry for that current
day sorted by division, then a subtotal for each division under that, then at
the bottom a day total.

Somebody please help!
Thanks
 
one assumes you have the Division as a grouping element with a footer per
Report design view

so I don't understand why you would not be able to establish a total for
each Division within its footer. I do not clearly understand what you mean
when you say:
"it is totaling each entry not grouping the data together by Division"

What is the code in your unbound division footer text box? it should
somethinglike
=Sum([FieldNameYouWantTotalled])
 
Back
Top