Help, how to topics > Custom Views > How do we run a report that shows which books haven’t been checked out in the last year?
-
Views, Statistics
- save a view
- views assistant
- ready-to-use views
- times checked out
- copies per title
- never loaned out items
- loans by year, month
- cost of not returned items
- loans per borrower
- statistics total purchase cost
- overdue items report with call, location
- library SQL sample, join 3 tables
- overdue items by borrower type
- overdue item by student class
- loaned out items by book format
- yearly circulations by item type
- items added in the last year
> items not checked out in the last year
- loaned out items report with call number
How do we run a report that shows which books haven’t been checked out in the last year?
Question:
How do we run a report that shows which books haven’t been checked out in the last year?
We are want to see what books haven’t been checked out so we can pull them from our library.
Our library isn’t that big so if we can remove the books that haven’t been read then we aren’t wasting
that space on books people aren’t reading.
Answer:
To generate a list of items that were not checked out in 2025, please copy and paste the SQL query
below into the Custom Definition Box, and then click "Display."
Please note that this process may take some time to complete.
To check for different years, simply adjust the year in the query accordingly.
- Copy the text from the above box.
- Paste the text into the Custom Definition Box (1).
- Click Display (2) to execute the query and show the result (3).
- Click Save View to save the view.
Handy Library Manager 4.5, review new features
Inquiries from Librarians and Libraries
ISBN Book Finder And Cataloging Tool
Library Web Search, review new web search
Library Search 4.0, review new desktop search
Getting started library video lessons
How to include library name on labels
Library, Data Entry Form Designer
Edit item or borrower data in the check-in/check-out window?
Link item lost fine with the PRICE data field?
Handy v3.2 supports letter tabs?
How to predefine library email messages?
How to update library data from the web with ISBN?
How to predefine library email messages?
Compilation of questions and answers from library requests will help you to make purchase decision.
How to verify if the item is checked out in the library main catalog window?
How to create a new record using Copy Selected Item?
Special Library, how to manage digital and paper document library?
What is the maximum number of library items?
Library Software for Small Libraries, Windows application
Handy Library Manager
small library software
library tour
library features
try now, download
cloud
library software reviews
Copyright © 2026 · All Rights Reserved · PrimaSoft PC