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.