Cumulative Totals - Please Help

[cbetts75]

Hi,
I'm having trouble trying to create an expression for generating cumulative totals by Month.

I believe this is the function I need to use -

DSum (expression, domain, [criteria] )

I need the layout to be as follows -

Months - Rows
Cumulative Monthly Despatches - Column

I have a field list with
Months
Despatches
Models

All of these are from another Query and 'Despatches' is an expression generated in the other query

Can anyone please Help?!

 

[EMP]

Take a look at this thread and the sample database:-

Update Qry (running sum)
http://www.access-programmers.co.uk/forums/showthread.php?t=107837

^