Programming a Account Statement Report

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

  1. silbon

    silbon New Member

    Joined:
    Sep 28, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    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.
    SILBON
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice