<div>
Sivasan,<br />
<br />
I think you are describing a &quot;running total&quot;. Can you share the query that you have written so far?<br />
<br />
- Paul N.
</div>


<div>
A running total is a trivial process in a report. &nbsp;You just use the RunningSum() property to create the value.<br />
<br />
However, it is much more of a problem in a query and it is also very inefficient and so may be extremely slow. &nbsp;The most efficient method is to do a self- join and sum all the rows with a PK &lt;= the current one. &nbsp;This of course only works if you actually have a numeric uniqueID that is ascending.
</div>


Sivasan

<div>
Hi Gustav Brock,<br />
Thank you very much. This is what I was looking for worked<br />
Thank you
</div>


<div>
Thanks for providing the fish Gus just in case the OP couldn't figure out my instructions.
</div>


<div>
<div class="content wysiwyg-content">
I have an access table with field ID, Item NoofHour this in sequence I like the keep summing the NoofHours <br />
so table Order<br />
id &nbsp;Item &nbsp;Hours<br />
1 &nbsp; &nbsp;abc &nbsp; &nbsp;5<br />
2 &nbsp; &nbsp;ccc &nbsp; &nbsp;10<br />
3 &nbsp; &nbsp;yyy &nbsp; &nbsp;2<br />
4 &nbsp; kka &nbsp; &nbsp; 3<br />
<br />
I want to make query so result are<br />
id &nbsp;Item &nbsp;Hours &nbsp; Totalhr<br />
1 &nbsp; &nbsp;abc &nbsp; &nbsp;5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
2 &nbsp; &nbsp;ccc &nbsp; &nbsp;10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
3 &nbsp; &nbsp;yyy &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 17<br />
4 &nbsp; kka &nbsp; &nbsp; 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20<br />
<br />
So add the above hours. I will appreciate if somebody can tell me how I can get &nbsp;sum &nbsp;of row above.<br />
Thanks
</div>
</div>


I have an access table with field ID, Item NoofHour this in sequence I like the keep summing the NoofHours 
so table Order
id  Item  Hours
1    abc    5
2    ccc    10
3    yyy    2
4   kka     3

I want to make query so result are
id  Item  Hours   Totalhr
1    abc    5             5                 
2    ccc    10           15                 
3    yyy    2             17
4   kka     3             20

So add the above hours. I will appreciate if somebody can tell me how I can get  sum  of row above.
Thanks

Sum the all the above rows of a field on another field in access query

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.