I have a table with name, date, hours & code - for example:
Alan,01/01/12,8,A80
Alan,02/01/12,8,A80
Bob,01/01/12,8,B80
Bob,02/01/12,8,B80
Bob,03/01/12,8,B81
I want to get the totals for each person categorised by the last two characters of the code:
Name,Total 80, Total 81 - giving:
Alan,16,0
Bob,16,8

I can easily get the SUM for each name, but I don't know how to break it down by the code.
Any suggestions?
Thanks