Handy Library Manager
 for Windows


Help, how to topics > Custom Views > How many times library items have been checked out?


How many times library items have been checked out?

Ready to use Handy Library Manager SQL queries: How many times library items have been checked out?


How many times books have been checked out?

This view displays TITLE, AUTHOR, IDNO, TIMES (number of times the item was loaned out). Loans are grouped by item id number.

To display more data fields in separate columns you have to group by all those fields. In this example the grouping is by B.TITLE, B.AUTHOR, B.IDNO

library loan statistics, number of times item was checked out

Click Save to save the custom view for future use.


How many times library items have been checked out (simple version)?

This view displays TITLE, TIMES (number of loans). Loans are grouped by item TITLE.

To group circulation transaction you can use item TITLE. Separate items with the same TITLE will be grouped.

number of times item was checked out by item title

Click Save to save the custom view for future use.



Question: Is there a way to tell how many times a book has been checked out?

Question: I am the new librarian and have not been shown how to run a report to show which books have a low circulation rate.



Copyright © 2024 · All Rights Reserved · PrimaSoft PC