Hi, All -- The following report takes several minutes to run, which leads to me the sad probability that my SQL skillz are ... weak: SELECT b.title, count(s.datetime) AS circs FROM statistics s JOIN ( SELECT itemnumber, biblionumber, homebranch, itype FROM deleteditems UNION SELECT itemnumber, biblionumber, homebranch, itype FROM items ) AS all_items USING (itemnumber) LEFT JOIN biblio b ON (b.biblionumber=all_items.biblionumber) WHERE all_items.itype = 'MAGAZINE' AND all_items.homebranch = <<Owning Library|branches>> AND s.itemnumber IS NOT NULL AND s.type IN ('issue') AND s.datetime BETWEEN <<Between (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>> GROUP BY b.biblionumber ORDER BY circs DESC The report did run much quicker when I eliminated the UNION statement & used just one of the Items tables. Would be grateful to know if there's a better way of writing this report. Many thanks, Cab Vinton Plaistow Public Library Plaistow, NH