Group Totals

[acss]

I have a report that groups 2 service descriptions with sum totals for each
and then a grand total at the bottom of the report. Is it possable to have a
grand total for each instead one grand total for both?

 

[Evi]

Don't know what Service Descriptions are but group by whatever field groups
each Service Description using the Sorting/Grouping box. Choose to have a
Header and Footer and put your =Sum(YourField) in this footer. If this
doesn't fit the bill then explain how the 2 service descriptions are
grouped.

Evi

 

[Al Campagna]

acss,
You'll need to group your data in order to get a per group total. (ex.
ServiceTypeAmount... for each ServiceType)
(use your own field/control names)
Your post would suggest grouping by ServiceType.
Add a ServiceType Group to the Grouping/Sorting dialog box, and indicate
you want a GroupFooter for that group.
Then, in that footer, a calcualted field with a ControlSource of...
= Sum(ServiceTypeAmount) will yield the individual totals.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."