Running Sum & Over Group - Problem
Posted on 2005-04-15
I've got a query that counts sales by day, and it groups the sales by <5K, >5K & Total sales for the day. What i'm getting towards is a number of sales by month, YTD & Overall (yes, all sales in the table).
I'm using a report with groups on Year & Month.
In the Month Footer, I have 2 sets of fields that sum TOTAL, 5K & 10K.
The 1st set has Running Sum: Overall and gives me an accurate cummulative total of all sales.
The 2nd set has Running Sum: No and gives me an accurate cummulative total of sales within the Month.
In the YEAR Footer, I have fields that sum TOTAL, 5K & 10K. These fields have Running Sum: Over Group. This function doesn't seem to work.
The values in the YEAR Footer are allways equal to the 'Running Sum: Overall' fields.
Can anybody explain why this SIMPLE grouping isn't working? I think I'm a little to close to the problem.
Any suggestions for a better process? I want this to remain a report because I need to share these results.
Any help would be appreciated.