1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Programming a Account Statement Report

Discussion in 'Meet and Greet' started by silbon, Sep 28, 2010.

  1. silbon

    silbon New Member

    Sep 28, 2010
    Likes Received:
    Trophy Points:
    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.

Share This Page