Summarizing group totals in report footer

[narasimharaosama]

hello

I have totals of a field of each group in group footer.Now I want to
get the group totals as a summary in the report footer.Hope somebody
can help me out in this.

Sama

 

[Jeff Boyce]

I don't know what your underlying data looks like, so I'll have to make an
assumption that your detail level group has individual/detail amounts in a
field, and your group footer sums up all those individual/detail values.

To get a report-level summary, you'll have to sum up all the
individual/detail values.

Create a text control, and in the ControlSource property, put something
like:

=Sum([YourDetailValueField])

Note that this does NOT refer to the name of the control, but to the
underlying data field.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Marshall Barton]

I have totals of a field of each group in group footer.Now I want to
get the group totals as a summary in the report footer.Hope somebody
can help me out in this.

If you want a list of the groups and the total for each
group in the report footer, then I suggest that you use a
subreport based on a totals query that is based on the
report's record source query. E.g.

SELECT groupfield, Sum(amountfield) As GrpTotal
FROM reportquery
GROUP BY groupfield

 

[narasimharaosama]

Thanks for the replies,I think my previous mail was not that
informative....I am explaining the situation clearly below

There is a field called "Total cost" for each Group(which is Dept in
this case).I have summed up the individual values of this field "Total
Cost" in the group footer for each group, which give me aggregate
total cost of each group at the group footer.Now as the groups are
many and same is the case with number of other fileds,I want to
summarize the report with just Dept name i.e group name and the
aggregate total (sum of total cost field of that group) in the report
footer.


For Example

Dept1 Aggregate Total1
Dept2 Aggregate Total 2


Thanks
Sama

I don't know what your underlying data looks like, so I'll have to make an
assumption that your detail level group has individual/detail amounts in a
field, and your group footer sums up all those individual/detail values.

To get a report-level summary, you'll have to sum up all the
individual/detail values.

Create a text control, and in the ControlSource property, put something
like:

=Sum([YourDetailValueField])

Note that this does NOT refer to the name of the control, but to the
underlying data field.

Regards

Jeff Boyce
Microsoft Office/Access MVP

hello

I have totals of a field of each group in group footer.Now I want to
get the group totals as a summary in the report footer.Hope somebody
can help me out in this.

Sama

 

[Marshall Barton]

There is a field called "Total cost" for each Group(which is Dept in
this case).I have summed up the individual values of this field "Total
Cost" in the group footer for each group, which give me aggregate
total cost of each group at the group footer.Now as the groups are
many and same is the case with number of other fileds,I want to
summarize the report with just Dept name i.e group name and the
aggregate total (sum of total cost field of that group) in the report
footer.

For Example

Dept1 Aggregate Total1
Dept2 Aggregate Total 2

As I said before, use a subreport.