>>I don't have Nortwind here. But this is not the running total, this is just a sum of all order details for each Order record. What exactly did you want to produce? Running total usually involves dates.
>
>Yes, I want a running total. I'm not too sure how to do that.

What is your table structure and what do you mean by running total?

Check also http://www.developerfusion.co.uk/show/1734/