Hi Barton, I’m using this report: SELECT biblio.biblionumber,(select count(*) from reserves where biblionumber=biblio.biblionumber) as holdsonbib, items.barcode,items.itemcallnumber,biblio.title,items.issues,items.itemnotes,items.enumchron,items.onloan,items.notforloan,items.damaged,items.itemlost,items.withdrawn,items.datelastborrowed,items.datelastseen,items.dateaccessioned FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.ccode='XDVDBR' ORDER BY biblio.biblionumber I’m downloading the report as tab separated text, opening in Excel, conditional formatting the biblionumber column to highlight duplicate values in red, and filtering by cell color. Mike From: Barton Chittenden [mailto:barton@bywatersolutions.com] Sent: Tuesday, December 20, 2016 8:45 AM To: Michael May <mmay@dubuque.lib.ia.us> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Report for bibs with multiple items with item details On Mon, Dec 19, 2016 at 1:25 PM, Michael May <mmay@dubuque.lib.ia.us<mailto:mmay@dubuque.lib.ia.us>> wrote: I apologize. I've figured out how to add biblionumbers to a report of all items, and then how to identify and isolate duplicates in the downloaded spreadsheet. This pretty much does what I want. Thanks for listening. :) -Mike No need to apologize -- would you mind giving a more detailed description of what you did? Thanks! --Barton Click here<https://www.mailcontrol.com/sr/xBfa6Ks6MQ3GX2PQPOmvUubKwjUTrb0OnVqnnCxrXurEf54fsRkDBtg31lSFhtsBEGEwoHiksOqsCq9I+zBdpQ==> to report this email as spam.