20 Nov
2013
20 Nov
'13
3:14 a.m.
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