Kerrie, Are you just wanting count of items per collection code at a set branch? And no other information displayed? If so, try
SELECT items.ccode, count(items.itemnumber) FROM items WHERE items.homebranch=<<Home branch|branches>> GROUP BY items.ccode That should get you what you are you looking for, if I'm understanding what you're after correctly. Here's a quick breakdown of above report, if you're interested: SELECT line = the data columns you're going to display in the report. (ccode, counting something) FROM = the table where the data is going to come from (items) WHERE = your criteria (limiting to a branch parameter) GROUP BY = How your data is grouped (in this case by collection code) Hope that helps. Heather Braum NExpress Coordinator Resource Sharing Librarian Northeast Kansas Library System [email protected] "The illiterate of the 21st century will not be those who cannot read and write, but those who cannot learn, unlearn, and relearn." ~Alvin Toffler, *Rethinking the Future* On Wed, Mar 9, 2016 at 11:46 PM, Kerrie Stevens <[email protected]> wrote: > I'm trying to get a report to show the number of items in each collection > code according to the branch selected. I've looked in the reports library > but can't find anything that is exactly right. I've tried to mix'n'match > bits from a few reports but I keep getting an error message about syntax. > > This is what I have so far: > SELECT > items.ccode,items.itemcallnumber,items.itype,biblio.author,biblio.title, > biblio.copyrightdate > COUNT( i.barcode ) AS "Count" > FROM items > LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) > WHERE items.homebranch=<<Home branch|branches>> > ORDER BY items.dateaccessioned DESC > > Any help, much appreciated. > Thank you > > Kerrie > Harvest Bible College > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
