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
[email protected]
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>
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
