On 9 November 2010 16:17, Kathy Rippel <kdr@ckls.org> wrote:
Yes, Chris, I believe that is what she wants.
In that case SELECT COUNT(DISTINCT(borrowernumber)) FROM statistics WHERE (type='issue' OR type = 'renew') AND datetime > '2010-10-01' AND datetime <= '2010-10-31' ; That will give you the count for October, tweak the dates to suit Chris
Kathy
At 05:25 PM 11/8/2010, Chris Cormack wrote:
* Kathy Rippel (kdr@ckls.org) wrote:
I am having trouble figuring out a report that shows the following: Number of patrons circulating (issue and renew total) items in a given month. We can do numbers of items circulated by patron category, etc., but my librarian wants to know how many PATRONS actually circulated items in a given month. Any help from the collective brain? Please forgive the cross-posting.
Hi Kathy
You want distinct number of borrowers? Ie, if someone has had something issued to them twice, just counted once?
Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand
Kathleen D. Rippel Dept. Head/Consultant--Resource Sharing and Access ; Pathfinder Central (Manager) Central Kansas Library System 1409 Williams Great Bend, KS 67530
(620-792-4865) phone (800-362-2642) toll-free, KS (620-792-5495) fax
kdr@ckls.org ******************************************************************************************** I'm currently reading: Only a Few Bones, by John Philip Colletta I'm currently listening to: The Bridge of San Luis Rey, by Thornton Wilder
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha