Hi What is the problem with this Report for getting the fine collection in between date ranges. The result is showing minus amounts. Eg: -6, -5 etc.
SELECT borrowers.cardnumber,borrowers.surname,accountlines.date,accountlines.amount FROM borrowers LEFT JOIN accountlines on (borrowers.borrowernumber=accountlines.borrowernumber) WHERE DATE(timestamp) BETWEEN <<Added BETWEEN (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>> AND (accounttype='PAY') Please help -- With Regards Prajeesh Bhaskaran Mahatma Gandhi University Library Kottayam, Kerala- 686 560 http://kerala-lis.blogspot.com/. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
