Handy Library Manager
 for Windows


Help, how to topics > Custom Views > What is the total cost of library items?


What is the total cost of library items?

What is the total cost of library items by item type?

Ready to use Handy Library Manager SQL queries: What is the total cost of library items?
What is the total cost of library items by item type?


library items: enter price, 
replace value, current value

Enter prices, replace costs, or current values for your library items.

In this example we will use PRICE values.


1. What is the total number and total purchase cost of all library items?

Purchase price (PRICE) is recorded in the library copies table (LIB_COPIES).

COUNT(*): calculates total number of items.

SUM(PRICE): calculates total price for all items.

Select the text and copy it: click with the right mouse button on the box to open a popup menu, use Select All and then Copy commands.


copy paste the summary 
definition, review result

Copy and paste the above definition into the box (1).

Click Display (2) to review the result.

Click Save Stats (3) to save the statistic for future use.


save cost definition for future 
use

In the Save Statistics windows you can save the definition for future use.

Enter a name into the Save Statistics As box (1) and click Save (2).


2. What is the total number and total purchase cost of all library items by type?

Item type (TYPE) is in the main library table (LIBRARY, B).

Purchase price (PRICE) is recorded in the library copies table (LIB_COPIES, A).

We have to join two tables by the common field (IDNO).


save cost definition by type 
for future use

Copy and paste the above definition into the definition box (1).

Click Display (2) to review the result.

Click Save Stats (3) to save the statistic for future use.


graphical representation of 
the library cost summary by item type

Click Chart to display a graph (bar chart, pie chart, or line chart).


library administrator window, 
quick access to statistics

Saved statistics you can access quickly from the library administrator window.


library administrator window, 
table and chart statistics

Data is represented in the table or chart form.




Copyright © 2024 · All Rights Reserved · PrimaSoft PC