Cumulative sum

[jumilu]

Hi,

I have a table where the fields are Area (number), Month (text (rather than
date because some of the data in this field are "unknown")), and Power
(number).

An example of data in this table is:
Area Month Power
1 jun 2
1 jun 3
1 sep 2
1 sep 5
2 jan 6
2 jun 8
3 apr 10
3 apr 1
3 jun 2

I need a query that will provide the cumulative sum by Month of the Power by
Area.

Example of required output:
Area jan apr jun sep
1 5 12
2 6 14
3 11 13

I have tried building smaller queries and then using those in bigger queries
but I am getting nowhere. I've been trying to create this query in Query
Design rather than in the SQL view.

Any help will be GREATLY appreciated.

Thanks.

 

[Ofer Cohen]

Try a CrossTab Query, such as

TRANSFORM Sum(TableName.Power) AS SumOfPower
SELECT TableName.Area
FROM TableName
GROUP BY TableName.Area
PIVOT TableName.Month;