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

    Good Question?
    0
     

    ?

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

    Accepted Solution 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.

    Top Expert Contributor

    Essential articles and videos from the Experts

    More valuable questions with Expert answers

    201511-LO-Qu-074

    Extend your technology team with the Experts Exchange community.

    — trusted by —

    Who answers my questions?Our community has technology experts around the world.

    Rey Obrero

    18,505

    Solutions

    Expert in:

    • MS Access
    • Query Syntax
    • Visual Basic Classic
    • Databases-Other
    • MS Applications

    crystal (strive4peace)

    202

    Solutions

    Expert in:

    • MS Access
    • MS Excel
    • VBA

    Jim Dettman (Microsoft MVP/ EE MVE)

    7

    Articles

    5,371

    Solutions

    Expert in:

    • MS Access
    • MS Applications
    • Databases-Other
    • MS Development-Other
    • MS Office

    PatHartman

    1,251

    Solutions

    Expert in:

    • MS Access
    • VBA
    • Databases-Other
    • MS Applications
    • MS Excel

    Scott McDaniel (Microsoft Access MVP - EE MVE )

    11,135

    Solutions

    Expert in:

    • MS Access
    • Query Syntax
    • Visual Basic Classic
    • Databases-Other
    • MS Applications

    Dale Fye (Access MVP)

    9

    Articles

    2,980

    Solutions

    Expert in:

    • MS Access
    • Query Syntax
    • MS Applications
    • MS Development-Other
    • MS Office

    Rgonzo1971

    1

    Articles

    2,122

    Solutions

    Expert in:

    • MS Excel
    • MS Office
    • MS Access
    • MS Word
    • VB Script

    IrogSinta

    1,156

    Solutions

    Expert in:

    • MS Access
    • MS Applications
    • MS Excel
    • MS Office
    • Query Syntax

    Gustav Brock

    9

    Articles

    3,527

    Solutions

    Expert in:

    • MS Access
    • Query Syntax
    • Databases-Other
    • Visual Basic Classic
    • .NET Programming

    RELATED TOPICS view all topics

    1. Query Syntax
      (46,103)
    2. Visual Basic Classic
      (162,823)
    3. MS Applications
      (44,164)
    4. Databases-Other
      (53,010)
    5. MS Excel
      (125,160)
    6. MS Office
      (55,930)
    7. MS SQL Server
      (154,713)
    8. MS Development-Other
      (48,696)
    9. VB Script
      (35,491)
    10. MS SQL Server 2005
      (71,596)