Running Sums within a Query

[jimmyspinner]

Hi there,

I'm trying to create a running totals or cumulative totals query based on the following sample query in Access 2000. I'm trying to use a Dsum function based on a query not really getting the answer I'm wanting which is shown in the column Cumulative

QRY_DealsSummary is the query name

User; Team; Segment; MonthEndDate; Value; Cumulative
User A;A Team; Segment 1; 31/01/2011; 1000; 1000
User A;A Team; Segment 1; 28/02/2011; 1500; 2500
User B;A Team; Segment 1; 31/01/2011; 500; 500
User C;C Team; Segment 1; 28/02/2011; 2000; 2000
User C;C Team; Segment 1; 31/03/2011; 750; 2750

I eventually want to create a crosstab query showing the cumulative totals over time for each User

Firstly I'm not even sure I'm going about it in the right way and I've tried to think logically but my brain hurts

Can you help?

Thanks in advance

Dave

 

[MStef]

Look at "DemoQryrunSumA2000.mdb" (attachment, zip).
Look at Table1, Form1, Query1, Module1.
Open form1 and try.
I think it is what you need.

 

[MStef]

Here is a better one, (attachment,zip).
Look at Table1, Query1, (column 5), Module1.
Run query.