SQL in MS Access - Can you help?

[xtrec02]

First off, thank you to anyone who can help me.

 

In access i have a table with data which is attachment 1111.jpeg. The sql code to get that table is:

---------------------------------------

SELECT DISTINCT

 

SL2.ROLLUP_LEVEL_2_CD,

SL2.DIST_CAT_NUM,

Phoenix_With_Level_2_Level_3.May,

Phoenix_With_Level_2_Level_3.Jun,

Phoenix_With_Level_2_Level_3.Jul,

Phoenix_With_Level_2_Level_3.Aug,

Phoenix_With_Level_2_Level_3.Sep,

Phoenix_With_Level_2_Level_3.Oct,

Phoenix_With_Level_2_Level_3.Nov,

Phoenix_With_Level_2_Level_3.Dec,

Phoenix_With_Level_2_Level_3.Jan,

Phoenix_With_Level_2_Level_3.Feb,

Phoenix_With_Level_2_Level_3.Mar,

Phoenix_With_Level_2_Level_3.Apr

 

FROM Phoenix_With_Level_2_Level_3 LEFT JOIN SL2 ON Phoenix_With_Level_2_Level_3.ROLLUP_LEVEL_2_CD = SL2.ROLLUP_LEVEL_2_CD

 

WHERE (((SL2.VAL_DESC)='T'));

------------------------------------------

 

What i would like is to have the monthly data summed and organized by DIST_CAT_NUM and grouped by ROLLUP_LEVEL_2_CD (a result like 2222.jpeg attachment). I can do ALOT of work in excel but I know there is an easier way.

 

Can anyone help me and write a sql command to acheive the end result?

 

Im stumped and anything asap would be awesome!

 

[attachment deleted by admin]