Dynamic Cross Tab Report with running total

[pdavis41]

Disclaimer: This got way more complicated that I was planning on!

Ok so here is what I'm trying to do:

The report that I am trying to make is basically a general ledger sheet.
I am currently using the Microsoft Dynamic Cross Tab Report modified to my need.

Here is what the report needs to look like:
OrderDate | Payee | Total | Account# | Account # | ect.....
Data | Data | Data | Data | ect....
| Total | Total | Total | Total | ect....
I have this part working but if anyone sees anyway of doing that different let me know.

The part I'm having a problem with is that this report is done weekly and has to have a balance forward as part of the total. I have somewhat of a workaround right now but it involves 4 queries for each report and each week has to have its own report (there are 10 weeks).

There must be a way to do this with one report and a form to select the week, however I have a feeling this involves code and I'm not that up to date on my VB.

Here is a copy of the section I'm working on right now: http://www.lowaneuallanque.org/pdavis/dbsbm.zip

Thanks in advance for the help.

 

[pdavis41]

Bumb

I'm putting off working on this section of the program right now and working on another part. If anyone has any ideas please let me know.

 

[pdavis41]

I am thinking that the best way to approach this is with a seperate query and a subreport for the previous total.

Since I am loading the report by a form the query will pull the week number from the form and total everything previous to it.

The problem I am getting is that the report is spitting out a error. See attached database.