Creating Begining Balances in Access for Accounting

[Nubster]

Hi everyone, I am new to this board, but I am having a great deal of trouble trying to get this accounting database working. The only problem that I am having is getting my "Ending Balances" to show up as "Begining Balances" for the next month .

I created the "Ending Balances" in the report. Here is an example of the formula I used...

=Sum([Monthly_Ledger_Parent_Query]![Balance Sept 1st])

* This sums the total numbers for the Ending Balance of September for a month.

I then created a "Beginning Balance" in the report. Here is an example of the formula...

=IIf([RptStartDate]="09/01/02","0.00",[Balance Sept 1st])

* I set the "Begining Balances" for September only to show 0.00 dollars. However, the problem is that the formula does not pick up last months "Ending Balances" to show up for the currents month "Begining Balance."

Please help if you know what I am doing wrong. Thanks for your time.

V/R
Ray