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@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>