There is a report that does just that listed on this page: http://wiki.koha.org/doku.php?id=sql_library it's this one: SELECT borrowers.cardnumber, borrowers.surname, borrowers.firstname, FORMAT(SUM(accountlines.amountoutstanding),2) as due FROM borrowers LEFT JOIN accountlines ON (borrowers.borrowernumber=accountlines.borrowernumber) WHERE accountlines.amountoutstanding > 0 GROUP BY borrowers.cardnumber ORDER BY borrowers.surname ASC 2009/8/10 Akin Adigun <akinomatics@yahoo.com>
Hello, I am using koha 3.0.1 on suse 11.0 with nozebra configuration
Pls I need queries on modification log for patrons and queries on patron that have fine againt there record and having fine above the nochage amount
thanks
Akin Adigun *(MCP)* Akinomatics Tel: +2348035565348, +2348029219271
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha