Complicated Sub-Totaling...

[cheuschober]

Alright, here's what's up...

I'm attempting to create a report for my personal finances that basically re-creates a duplicate of my monthly credit statements for quick comparisons to my real credit statements for aberrations in charges. That means each set of data from each respective month has been grouped from the 15th of last month to the 16th of this month and, basically, all is well in the summing of the world except for my monthly subtotals. Each month you make a payment, say on the 18th for the last month's credit history. Right now, because the payment is happening in the 'current' month, my statement totals are being reduced by the payment from the previous month when I would like them to simply compound.

Let me put this more decisively:

The report has an ascending month grouping with descending dates.

I would like each respective subtotal (found in the monthly footer) to be able to carry the respective balance over from the last month, essentially creating a 'running sum' but better put, a running subtotal.

I've tried simply setting the property for the subtotal to 'running sum' but it only wants to work descending, it seems. Additionally, I attempted a DSum() function on my totals but I couldn't quite figure out how to force the criteria to only accept totals of months equivalent or less to that of the current month.

Any ideas on how to make this happen?

Thanks a bundle,
~Chad
--------------------------------------
Addendum:

So, I'm still having a bit of the same problem but I think I've taken steps to rectify it.

What I've done, is by a series of queries, I've obtained my monthly, compounding subtotals with the [Invoice Date] field as my key. Each respective [Invoice Date] has only one entry.

Now, back to my report:

The report has information shown for each record based on Date, then amount, payee, etc. Each record has an [Invoice Date] field that is calculated based upon the actual [date] of the transaction. So, if there are 30 transactions in a period ending 08/27/04, each transaction carries the [Invoice Date] of 08/27/04 and subsequently, in my subtotals query, each [Invoice Date] carries a compounded subtotal.

So, back to the report:

Each set of transactions is grouped by their respective [Invoice Date]. Now knowing that I have been able to calculate my subtotals and assign them each to a respective [Invoice Date] is there a way to display those subtotals in the footer of each [Invoice Date] grouping on the report?

I hope this is clear! Thank you so much everyone who takes their time and energy to help young 'ins like me. I've saved countless hours with your help.

Thanks again!
~Chad