Go4Expert (http://www.go4expert.com/)
-   Meet and Greet (http://www.go4expert.com/community/meet-and-greet/)
-   -   Programming a Account Statement Report (http://www.go4expert.com/community/programming-account-statement-report-t23437/)

silbon 28Sep2010 22:44

Programming a Account Statement Report
I am programming a Statement of Account which shows Date, Document Ref, Transaction Description, Debit, Credit and Running Balance columns.
The problem I am having is this: after the opening balance is shown in the Balance column, the next entry displays the running balance correctly but the subsequent entries display incorrect running balances. Here is a sample:
Date. Ref. Trans.Description Debit Credit Balance
01-9-10 Opening Balance 500.00
05-9-10 A/01 Purchases 200.00 .00 700.00
10-9-10 R/09 Payment recvd 400.00 1000.00

Please let me know how to program this in MS-ACCESS. A typical example with code will help greatly. Thank you very much.

All times are GMT +5.5. The time now is 04:10.