Running total with DSUM()

[ddeldeb]

I am trying to get a running total of payments from a table. I found some examples in this forum , but can not get them to work. To make things simple, I made a new table with 3 columns, Name, Date Amount and put about ten entries in it. Same name, incrementing dates and various amounts. Then I query that table with all three fields and with my DSUM field, but the DSUM just shows the total amount repeated in each row And it does this for what ever range I choose. What is the correct way to get a running total for a field.
Thanks ,

 

[bigbob]

Hi
In a different column to the one you are trying to sum just try =SUM(C:C) This assumes of course that there is nothing else in column C except your amounts
Big Bob

 

[ddeldeb]

I'm not sure I under stand your response? It looks more like what you would use in Excel and not in an Access database query. Tho, I did try variations of it in a query and got nothing.

 

[Ian Mac]

Have you looked at the RunningSum Property?

 

[CT Witter]

I would recommend doing the running sum in a report. However, if you need this in a query take a look at MS KB artticle : 205183 - How to Create a Grouped Running Sum in a Query

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

HTH,
CT

 

[ddeldeb]

The Running Sum property works fine to do a "from begining to current" report, But the end user wants to print out only a YTD "invoice". I have not figured out how to print just a range from a report, (from a renter whos account spans across years) other then having the user select... page 4-5-6 or what ever to print, Thats not acceptable. I was hoping to create a query to get the information needed, then run the report off of it. I will check out the MS article. I had been looking at KB articals 290136 & 208714. I also downloaded MS's sample access file Qrysmp00.exe. The DSum property works fine in this sample file and I am beginning to think I have a grouping priority problem. Hopefully article 205183 will shed some light on this

Thanks