Calculate Sum of a Calculated Field in Group Header

Posted on 2007-10-10
Medium Priority
Last Modified: 2013-11-28
I have a report with 2 group headers (X & Y).  Within the second group header (Y) I have a calculated text field (txtChemEmitted).

I've setup one group footer associated with the first (X) grouping.  I would like to have
=SUM([txtChemEmitted) in this group footer.  But it is not recognizing the field.  I tried putting it the Y Footer, but I have the same error?
Question by:iamlori
  • 2
LVL 61

Accepted Solution

mbizup earned 2000 total points
ID: 20051243
Sum the underkying field, not the control name

SHould be

=SUM([Field1] + [Field2])                 <--- or whatever the calculation is... using the actual field names

Author Comment

ID: 20051372
I was concerned that was the solution - the [txtChemEmitted] was a confusing calculation.  But after some different attempts - I got it to work!

Thanks for helping and helping me take a step back from the issue.
LVL 61

Expert Comment

ID: 20051380
Glad to help out :-)

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question