When I do a query, I get the following results (see attached image). I would like the January rows to be combined into one row, and the same for March. I cannot seem to get the desired results (in one query - without using a temporary table). I've done a bit of research, and can't find anything useful. Any help?
Solved! =) A friend of mine suggested http://www.artfulsoftware.com/infotree/qrytip.php?id=523 It seems I needed to move sum from the field itself and place it around the case statement.