Sub Totals

[Steven.Foy]

Hi wonder if anyone can help?

Am trying to create a Pareto Graph in Access. i have a column of data which has percentages attached to it. I need to create a running total in another column, so i can graph this column as an accumulative percentage i think?

Does anyone know how i can create a query to give a running total of a column? Or does anyone have any other suggestions!

Hope someone can help!

 

[Rich]

Search the archives here for running total, there have been some innovative suggestions

 

[Steven.Foy]

will have a search...am sure there must be an easy way of doing it.....but its elluding me so far!

I'm looking for sub totals rather than a running total though.

for example
data number column i need
a 1 1
b 3 4
c 1 6
d 9 15
e 4 19

Hope the example maybe clarifies what i mean!

 

[Rich]

It may be under Running Sum too

 

[Steven.Foy]

found some code...but not sure about my syntax!

I found an answer in the forum which suggested using an expression similiar to this :

Running Total: DSum("[Total]","Query1","Year([Year]) <= " & Year([Year]))

It was written by a user called ABBY i think.
I've tried to change it to suit my requirements...but to no avail...am not sure whats wrong, am also not sure what the lt bit stands for?

My data is held as Percentage of total, and it has a unique identifier MAT assigned to it. They are held in a qry called qryMATCodeParetoPercentages. It is the Percentage of Total field i wish to cummulatively total. and it is this field i wish to graph.....

Running Total : DSum("[Percentage of Total]","qryMATCodeParetoPercentages","MAT([MAT])<=" & MAT([MAT]))


Any more help or direction would be gratefully received!!!!

 

[Rich]

Is Mat a sequential key field?

 

[Steven.Foy]

MAT is a unique code within this query. In the previous esimple example i gave the "data" column (containing a, b, c, d, e wou) would be equivalent to MAT.

 

[Steven.Foy]

Still struggling

Am still unable to do this!!!!!! help!!!!

This is one of the last things i need to do to be able to complete the package i'm currently working on!

Does anyone have any ideas????