If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Summarizing group totals in report footer
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 |
#2
|
|||
|
|||
Summarizing group totals in report footer
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 wrote in message oups.com... 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 |
#3
|
|||
|
|||
Summarizing group totals in report footer
|
#4
|
|||
|
|||
Summarizing group totals in report footer
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 On Aug 9, 12:28 pm, "Jeff Boyce" wrote: 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 wrote in message oups.com... 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 |
#5
|
|||
|
|||
Summarizing group totals in report footer
|
Thread Tools | |
Display Modes | |
|
|