Calculate Sum of a Calculated Field in Group Header

Posted on 2007-10-10
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
    LVL 61

    Accepted Solution

    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

    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

    Glad to help out :-)

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    754 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now