Cummulative Sum

[kbsudhir]

Hi,

I want to generate a cumulative sum of a value of Items. I am arranging the complete data set in decending order of the value of items. Then get the cummulative sum of the values. Please guide me on how to create a query on this.

Fields are "Item_Name" & "Item_Value".

Regards
Sudhir

[pbaldy]

Try

SELECT Item_Name, Sum(Item_Value) AS TotalValue
FROM TableName
GROUP BY Item_Name

[kbsudhir]

Hi Paul,

Thanks for the time & efforts. But I think I am was not able to explain the properly. I need running total of Item Value. I made the below query but of no use.

SELECT Query2.SL_No, Query2.Material, Query2.[2012_Stock Value], DSum([Query2].[2012_Stock Value],[Query2],"[SL_No] <" & [Query2].[SL_No]) AS Expr1
FROM Query2;

While running the above query its asking to "enter parameter value" for Query 2 which I am leaving blank & in the query results I am getting "Expr1" value as #Error.

Please guide me on where I am going wrong.

Regards
Sudhir

[Bob Fitz]

May be this link would help: http://support.microsoft.com/kb/290136

[kbsudhir]

Hi Bob,

Thanks for your time. I already used the link provided by you to understand the concept of DSUM. Thats the reason I created the field for SL_No that I can use that for the criteria. But still I am getting the error.

Hence I am confused about where I am going wrong.


Regards
Sudhir

[pbaldy]

The first two arguments need to be in quotes.