I have a report that has 2 sections (Header/Footer). In the first section I have several plantings that each display the individual acreage for the entries listed. For the sake of simplicity say, 5 acres, 4 acres, 4 acres, and 5 acres. The cell information I used is [SumOfAcresPlanted] for this step
In the first section, the footer is set up to subtotal the acreage for that plant variety, in this example 18 acres. This works just fine. There are several of these subsection that print in the report. In the footer for the first section, I entered =Sum[SumOfAcresPlanted) and it works perfectly
However, when I get to the 2nd section, nothing I've tried will let me total the subtotals from each of the different varieties into one Grand total. Obviously =Sum(Sum[SumOfAcresPlanted]) is no good. All I've learned is that you can't nest a Sum Function within a Sum Function in Access 2003.
I've also tried using the Text Box name from the cell in the first section in a Sum function with no success and an SQL where clause isn't working either.
Can anyone give me some guidance on this?