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])
"Mia" wrote:
[Quoted Text] > 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
|