Maybe something like this: SELECT statistics.datetime, items.itemcallnumber FROM statistics LEFT JOIN items on (items.itemnumber = statistics.itemnumber) WHERE statistics.type = 'issue' AND statistics.datetime >= concat(date_format(LAST_DAY(now() - interval 1 month),'%Y-%m-'),'01') AND statistics.datetime <= LAST_DAY(now() - interval 1 month) ORDER BY items.cn_sort asc This will run for whatever the month before today is. If you want hardcoded dates, you can substitute them for the datetime => and <= where statements. Note that when I tried this on a production server, the number of entries easily exceeded Koha's dratted 10,000-line download limit. See the bugzilla entry for that problem and workaround: http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3419 Jane Wagner Library Systems Analyst PTFS Inc. Content Management and Library Solutions 6400 Goldsboro Road, Suite 200 Bethesda, MD 20817 (301) 654-8088 x 151 jwagner@ptfs.com -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Cab Vinton Sent: Tuesday, January 12, 2010 10:08 AM To: Koha list Subject: [Koha] Circulation report w/ each item We break our circulation statistics down in a number of ways & for the moment at least the best way to get these will be to produce a circ report listing the call number & checkout date for each item. Can anyone provide some help with producing a report in this format? Thank you, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha