<div>
You can try:<br />
<br />
Balance = [MaintenanceCost] - Max[Cumulative]<br />
<br />
Flyster
</div>


You can try:

Balance = [MaintenanceCost] - Max[Cumulative]

Flyster

<div>
<div class="content wysiwyg-content">
I have one table ClaimDetails and it has entities named RepairMount and MaintenanceCost. I have calculate cumulative amount for Repair Amount using running sum.<br />
e.g Repair Amount &nbsp; &nbsp; &nbsp;Cumulative <br />
&nbsp; &nbsp; &nbsp; &nbsp;150 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 150 <br />
&nbsp; &nbsp; &nbsp; &nbsp;100 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 250 <br />
&nbsp; &nbsp; &nbsp; &nbsp;50 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300<br />
<br />
how am i going to calculate balance of the Maintenance Cost using cumulative amount? My calculation formula should be :<br />
Balance = [MaintenanceCost] - [Cumulative]<br />
The figure I had is wrong.<br />
eg. Maintenance Cost = 1000 when i run the calculation, it shows balance = &nbsp;850 instead of 700. I believe it takes the first number (150) and not the last number (300).<br />
how to make system recognize the last number which is the total of cumulative amount?<br />
please help.....<br />

</div>
</div>


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


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

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.