How can I embed a beginning balance in a check register?

[gusbrunston]

My friends:

This little knot is evading all efforts to untie it:

I have finished designing a checking account register report. Should look sort of like this:

Date       Trans #  Etc.  Deposit  Payment  Balance

10/31/01   Beginning Balance                $20,000
11/01/01   000325         $10,000           $30,000
11/02/01   048915                  $5,000   $25,000
11/03/01   000326         $   600           $25,600
11/04/01   048916                  $  725   $24,875

I've got it all done except: I can't figure out how to embed the beginning balance as of 10/31/2001 (the effective date we'll eventually use to implement this database.)

I'm using Running Sum in the "Balance" column (which is the "Deposit" column minus the "Payment" column).

Put me out of my misery and tell me how simple this is! I'll work on it too.

Thanks, so much
Gus Brunston An old PICKer, using Access2000
padregus@attbi.com

 

[gusbrunston]

Well,

I fixed it. I guess I had to spell it out in a thread to think about it. I use a delete query, and two append queries to build a temporary table and then run the report from a select query based on the temporary table. All I had to do was go back and enter a record in the base table where I keep deposits, and put it in as if it were a deposit. Makes sense to me now, but an hour ago I was buried in queries!

Thanks anyway,

Gus Brunston An old PICKer, using Access2000
padregus@attbi.com