> I would like to generate a report based on all the returned books on a > specify date
Returns are tracked in the statistics table, where the 'type' column contains 'return,' and the return date is in the 'datetime' column. I'm not good at efficient SQL, so I won't try to suggest a query that returns user-friendly data from biblio (for instance). You can get more ideas from the SQL reports library: http://wiki.koha-community.org/wiki/SQL_Reports_Library -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
