[Koha] Collection Code Totals

[Kerrie Stevens]

I am trying to run a report to give me the total number of items within each of our collection codes (we have 5) at each branch but I can only get it show me the results from one of them... can anyone see where I'm going wrong?

SELECT count(ccode), ccode AS collection
  FROM items
   WHERE items.homebranch='VIC'
  ORDER BY items.dateaccessioned DESC

I have looked through the Reports Library but can't find anything to do this. I've tried to adapt others but without any luck.

Any help is much appreciated.

Thank you,

Kerrie Stevens