How to calculate cumulative figure in report and balance using total cumulative figure

Posted on 2006-04-26
Last Modified: 2008-02-01
I have one table ClaimDetails and it has entities named RepairMount and MaintenanceCost. I have calculate cumulative amount for Repair Amount using running sum.
e.g Repair Amount      Cumulative
       150                           150
       100                           250
       50                             300

how am i going to calculate balance of the Maintenance Cost using cumulative amount? My calculation formula should be :
Balance = [MaintenanceCost] - [Cumulative]
The figure I had is wrong.
eg. Maintenance Cost = 1000 when i run the calculation, it shows balance =  850 instead of 700. I believe it takes the first number (150) and not the last number (300).
how to make system recognize the last number which is the total of cumulative amount?
please help.....
Question by:cujee75
    LVL 28

    Accepted Solution

    Can you show the corresponding MaintenanceCost data?
    How is Balance = MainteanceCost-Cumulative different from
    Balance = MaintenanceCost - sum(RepairAmount)?
    LVL 22

    Expert Comment

    You can try:

    Balance = [MaintenanceCost] - Max[Cumulative]


    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now