DSum running total (cumulative) (1 Viewer)

[Ajit Singh]

Hello

I need running (cumulative) total in a query and the query is the outcome of multiple queries / tables. Field am using is

unit: uds_unit_description (domain : qry_tbl_subdivision_and _code)
x: month_date (domain : tbl_calendar)
y: y1 (domain : ba1)

I need running total of y by unit and x. For example if unit is a and has 12 months....then running total for a should be calculated for 12 months.

Am using the below formula to calculate the running total.....but no luck....please help

Total: y2: DSum("y","query1",[x]<=#31-Dec-13#)

 

[bob fitz]

What data type is field [x]

 

[Ajit Singh]

date......25-Jan-2013, 25-Feb2013.....etc

 

[burrina]

Here is an example of a Running Sum. Of course that can mean different things to different people. I threw this together in a hurry as an example!

HTH

 

[Ajit Singh]

Thank You......I made it work my way.

 

[burrina]

Glad to hear it. Good Luck With Your Project.