<div>
I was concerned that was the solution - the [txtChemEmitted] was a confusing calculation. &nbsp;But after some different attempts - I got it to work!<br />
<br />
Thanks for helping and helping me take a step back from the issue.
</div>


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.

<div>
<div class="content wysiwyg-content">
I have a report with 2 group headers (X &amp;&nbsp;Y). &nbsp;Within the second group header (Y) I have a calculated text field (txtChemEmitted). <br />
<br />
I've setup one group footer associated with the first (X) grouping. &nbsp;I would like to have<br />
=SUM([txtChemEmitted) in this group footer. &nbsp;But it is not recognizing the field. &nbsp;I tried putting it the Y Footer, but I have the same error?
</div>
</div>


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?

Calculate Sum of a Calculated Field in Group Header

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.