Calculating Grouped Report Values
I currently have a report that has two Group's which I am going to call "G1" (outer) and "G2" (inner). In G2's Header I've placed a numerical valued textbox from the detail section. In G1's Footer, I've taken that textbox and placed it in a Sum Function. The problem is that instead of summing the single value displayed in G2's Header, its summing the value as if it was in the detail section. Question, how can you get Access to perform the Aggregate Function after Grouping versus before. Appreciate any help you can provide.