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]