Debit  - Credit Calculation

    Question by:
    On

    Topics:

    I'm developing Accounts & Receivable Module. I find difficult when I calcuate the debit credit calculation, for e.g.

    My report figure should be

    Date          Particular     Debit     Credit     Balance
    1/2/2002     Inv 292             $1200          $1200
    2/2/2002     Paymnt 219          $ 500     $ 700
    5/2/2002     Inv 392          $200          $ 900
    6/2/2002     Inv 394          $ 50          $ 950

    In above statement, how can I calculate the Balance in Access.

    Before this type of question posted also in
     http://www.experts-exchange.com/Databases/MS_Access/Q_20338642.html

     

    Verified Answer?

    The member who asked this question verified this comment provided the solution that solved their problem.

    by:Posted on 2003-04-10 at 20:55:01ID: 8311278

    You almost had it with that link you provided.

    All you need to do is put a text field in the detail section under balance. In the control source for that text box put:
    =[DEBIT]-[CREDIT]
    Now the part you were missing:
    9 boxes below the Control Source in the properties window you should see Running Sum. Change that to Over All and that should do it.

    This content is available to Experts Exchange members

    See the answer now
    with your Free 30 Day Trial

    Get unlimited access to solutions & experts

    • 4,169,477 solved questions
    • 3,805 articles & videos
    • 15,413 tech experts

    Get Access Now

    Ask Your Tech Question. Get Expert Solutions.We will email you when an expert has commented on your question.

    We will never share this with anyone. Privacy Policy Terms of Use

    Select topics

    You may select up to five topics.

    Top Expert Contributor

    Essential articles and videos from the Experts

    More valuable questions with Expert answers

    201507-LO-Qu-065