Vicki<br>You might find this page helpful: <a href="http://www.nexpresslibrary.org/training/reports-training/">http://www.nexpresslibrary.org/training/reports-training/</a> < you can copy/paste most of those statements into Koha.<br>
<br>For ccode/shelving location, it's - just update the 04 to whatever month you want:<br>SELECT count(i.biblionumber) as added, i.ccode, i.homebranch, i.location from items i WHERE YEAR(i.dateaccessioned) = 2009 AND MONTH(i.dateaccessioned) = 04 GROUP BY i.homebranch,i.ccode,i.location ORDER BY i.homebranch,i.ccode,i.location asc<br>
<br>For the fancy video version of our suite of monthly stat reports...visit: <br><a href="http://www.nexpresslibrary.org/category/tutorial/">http://www.nexpresslibrary.org/category/tutorial/</a> and scroll down until you get to the monthly circ videos.<br>
<br>Long live Jing.<br><br>Sharon Moreland<br>NExpress Shared Catalog<br>Northeast Kansas Library System<br><br><div class="gmail_quote">On Tue, May 26, 2009 at 4:41 PM, Vicki Teal Lovely <span dir="ltr"><<a href="mailto:vtl@scls.lib.wi.us">vtl@scls.lib.wi.us</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Does anyone know if you can circulation statistics for Shelving Location<br>
and Collection code by location? In Koha we may need to use a<br>
combination of these two codes for display purposes. This will make it<br>
difficult to get statistics since there could be many different<br>
combinations created in the item database.<br>
<br>
In Dynix the display function and statistical function are separated.<br>
<br>
--<br>
Vicki Teal Lovely<br>
<br>
<a href="mailto:vtl@scls.lib.wi.us">vtl@scls.lib.wi.us</a><br>
<br>
Software Applications Supervisor<br>
SCLS Automation<br>
201 W. Mifflin St.<br>
Madison, WI 53703<br>
<br>
(608)261-9109<br>
<br>
_______________________________________________<br>
Koha mailing list<br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Sharon Moreland<br>Technology Consultant<br>Northeast Kansas Library System<br>