quote:

---

Although I use these methods myself, I support Jonathan in that you *should* consider doing this not on the server, but within your reporting engine.

I know this very easily be done with Access Report generator and I bet other programs have a similar functionality.

Just add a text box to your report and set the following properties for it.

Property      Setting

RunningSum    Over Group or Over All

ControlSource =1

Works like a charm.

Frank

http://www.insidesql.de

---

I don't know Acess, but it's that easy in Crystal, and also easy in Excel, which I do know pretty well:

  Range(Cells(1, 2), Cells(aRst.RecordCount, aRst.Fields.Count) + 1) = Application.Transpose(aRst.GetRows)

  Range(Cells(1, 1), Cells(aRst.RecordCount, 1)).FormulaR1C1 = "=RANK(RC5,R1C5:R" & aRst.RecordCount & "C5)"

--Jonathan