Try something like this:
SELECT round(Sum(accountlines.amount),2) AS 'Writeoffs Last 3 Months' FROM accountlines WHERE accounttype = 'W' and date like concat(date_format(LAST_DAY(now() - interval 3 month),'%Y-%m-%')) (haven’t tested this variant, but I run similar reports for 1 month and payments) Jane Wagner Senior Project Manager LibLime, a division of PTFS Content Management and Library Solutions 11501 Huff Court North Bethesda, MD 20895 (301) 654-8088 x 151 jwag...@liblime.com <jwag...@ptfs.com> *From:* koha-boun...@lists.katipo.co.nz [mailto: koha-boun...@lists.katipo.co.nz] *On Behalf Of *Peel Lisa *Sent:* Wednesday, October 19, 2011 3:08 PM *To:* 'koha@lists.katipo.co.nz' *Subject:* [Koha] report help - total amount writeoff Hello Report help again I am afraid! Could anyone supply me with the SQL for a report which will show me the amount of fines being written off at a specific library for a given period of time (for example the last three months?) Regards and thanks in advance Lisa [image: Description: Description: Description: CR_logo_POS_COULEUR b]** * * * * *LISA PEEL, PGDip, MA.*** Librarian César Ritz Colleges Switzerland 1897 Le Bouveret - Switzerland Tel: +41 24 482 82 82 Fax: +41 24 482 82 80 E-mail: *lisa.p...@ritz.edu <hortense.ho...@ritz.edu>* http://www.ritz.edu - http://www.culinaryarts.ch
<<image001.jpg>>
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
