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

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).

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.

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

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

Data is represented in the table or chart form.