SELECT count(*) FROM statistics WHERE type = 'issue' AND datetime > '2008-04-30' AND datetime < '2008-05-01'
Comparing this method with Josh's instructions for running the report in Koha: Koha reports 40705 circulations for all branches during the month of July 2008. I ran this query in mysql: select count(*) from statistics WHERE type = 'issue' AND datetime > '2008-06-30' AND datetime < '2008-08-01'; ...and got 44227. It looks like the reports interface in Koha is using the same logic as the SQL statement, so if you choose "Jul 1" through "Jul 31" on the date-pickers the report will not include circulations from those dates. Selecting "June 30" and "Aug. 1" as the start and end dates produces results that match the SQL. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org