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>