Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 18 Apr 2011 at 11:16am
Will the two groups to be totalled always be the first and second group? If so, set up a running total that never resets and display it at the end of Group2. It will contain the value before the Group3 data is added.
I think I'm getting the picture now...I can use running totals to make sums of different fields with specific conditions, then add them together in formulas.
In this case I'm doing variations of that theme throughout the report, so giving myself little running totals and putting them together as needed seems like the way to go.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum