Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sum multiple fields in a group 1

Status
Not open for further replies.

josephwc

Programmer
Oct 13, 2005
83
US
Crystal 11
Data Source: Microsoft Access XP query

I have added 36 fields in an access query to be added to a perviously existing Crystal Report.

I have 4 Groups and a Grand Total section. Is there any way to select all these fields at the same time and create summaries in all groups plus the Grand Total. (I am currently selecting each field individually with the sum icon)

Thank you
 
If you had CR 8.5 you could create group summaries and grand totals simultaneously, unfortunately they decided that was too efficient starting with CR 9.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top