report / running sum and sorting

[Guest]

I did crate a report with running sums and a calculation based on the running
sum.

Looks like :

Wim 3 ( running sum ) 6 ( running sum) 2 ( calculation 6/3)
Jan 4 ( running sum ) 12 ( running sum) 3 ( calculation 12/4)

next thing i want to do is a SORT based on the calculated field ( in the
report )
But i do not see how to do it ...

In anoher report did i make a calculation based on SUM in the query and than
its no problem to sort in it in the report. Can i do a running sum in the
Query or do i need to look for the solution in my report ?

Many thanks for your help !

 

[Wayne Morgan]

To sort on it, you'll need to do the running sum in the query so that you
will have a value to sort on. For an example of a running sum in a query,
see this article.

http://support.microsoft.com/default.aspx?scid=kb;en-us;138911&Product=acc97