[Koha] Generating dollar value reports

Paul A paul.a at navalmarinearchive.com
Thu Jul 23 11:36:00 NZST 2015


At 03:13 PM 7/22/2015 -0700, Michele Martin wrote:
>I'm a newbie, so I apologize if this is a dumb question, but I'm under a
>time crunch and need some help.
>
>How can I run a quick report that tells me the dollar value of our
>library's inventory?

If you record the price in "items":

SELECT SUM(price) FROM items;

will give you the total.
Paul

>I've got a report for the total number of items by
>type, but can't figure out how to generate the $$$.
>
>Many thanks, and please feel free to email me directly with any suggestions.
>
>Best,
>
>*Michele Martin*
>
>
>
>
>*Director of Information Science (Librarian)Sonoma Academy2500 Farmers
>LaneSanta Rosa, CA 95404707.545.1770*
>_______________________________________________
>Koha mailing list  http://koha-community.org
>Koha at lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

---
Maritime heritage and history, preservation and conservation,
research and education through the written word and the arts.
<http://NavalMarineArchive.com> and <http://UltraMarine.ca>



More information about the Koha mailing list