[Koha] Report needed: Number of patrons circulating items in a month

Chris Cormack chris at bigballofwax.co.nz
Tue Nov 9 16:30:55 NZDT 2010


On 9 November 2010 16:17, Kathy Rippel <kdr at 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 at 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 at 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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>


More information about the Koha mailing list