David - At Nelsonville Public Library, we login to MySQL and issue the following command to get our monthly acquisition statistics: SELECT biblioitems.itemtype, COUNT(biblioitems.itemtype) AS count FROM items,biblioitems WHERE YEAR(items.dateaccessioned)=2003 AND MONTH(items.dateaccessioned)=11 AND biblioitems.biblioitemnumber=items.biblioitemnumber GROUP BY biblioitems.itemtype; You'll need to change this by putting in the correct year and month, of course. The report is subdivided by item type. BTW, when you first start using Koha, _every_ item will be "new." But after that first month, the report should be accurate. Stephen Hedges

Dear Librarians,

At our small school (Thailand) we are using Koha and would like to do away with our on-paper catalog system. We have updated to the most recent stable version of Koha but do not see a way to get a weekly or monthly report of new books (acquisitions). It appears this is the main stumbling block to going completely online. Any experience and/or advice would be appreciated.

Oh, and is there a way to add jacket cover photos or Web-based links relevant to a book or its author?

Thank you in advance for your help.

Sincerely,

David Bucknell

-- http://iteachnet.org/~david

-------------------------------------------------- -------------- This message was sent using IMP, the Internet Messaging Program. _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha