S
Subtotals - not reinitializing
My report is based on a query. I am using sorting & grouping, and have a
group header and footer for month and year. The data fields are Year, Month,
Account, Amount.
I am reporting each account's amount, and want a subtotal of all accounts
for each month, then subtotals for each year, with a grand total at the end.
My problem is that the subtotals are cumulative (not reinitializing to zero).
Example
Year Month Account Amount
2000
01 632 100.00
01 456 200.00
Total for month 300.00
02 444 50.00
02 456 150.00
Total for month 500.00 (should be 200.00) - bringing
in 300 from previous subtotal
group header and footer for month and year. The data fields are Year, Month,
Account, Amount.
I am reporting each account's amount, and want a subtotal of all accounts
for each month, then subtotals for each year, with a grand total at the end.
My problem is that the subtotals are cumulative (not reinitializing to zero).
Example
Year Month Account Amount
2000
01 632 100.00
01 456 200.00
Total for month 300.00
02 444 50.00
02 456 150.00
Total for month 500.00 (should be 200.00) - bringing
in 300 from previous subtotal