Handy Library Manager
 for Windows


Help, how to topics > Custom Views > How to create a report with the overdue books that includes the date due and the CALL number?


How to create a report with the overdue books that includes the date due, the call number, the category, or the location?

Ready to use Handy Library Manager SQL queries: How to create a report with the overdue books that includes the date due, the call number, the category, or the location?

"Our librarian wants to be able to look at the category so she can see if the item is on the shelf before she sends out reminders."

"I want to create a report with the overdue books, the date due and the call number. I don't see the CALL number as a field I can use in the report."


Over due items report with CALL data field included.

Tables and fields used in the query:

A - Loans table (LOAN), data fields: DUEDATE, RETURNDATE, ITEM_IDNO
B - Library Copies table (LIB_COPIES), data fields: CALL, IDNO
C - Libary Items table (LIBRARY), data fields: TITLE, AUTHOR, IDNO


library query, over due items report with call data included


Over due items report with CALL and CATEGORY data fields included.

Tables and fields used in the query:

A - Loans table (LOAN), data fields: DUEDATE, RETURNDATE, ITEM_IDNO
B - Library Copies table (LIB_COPIES), data fields: CALL, IDNO
C - Libary Items table (LIBRARY), data fields: TITLE, AUTHOR, CATEGORY, IDNO


library query, over due items report with call, category data included


Question: How can I add fields to the Manage Loans window. Our librarian wants to be able to look at the category so she can see if the item is on the shelf before she sends out reminders. Having to go back into the main window to look that information up seems rather cumbersome. We may consider upgrading to the current version if the feature is added, but I couldn't find it in the trial version. IT Volunteer

I want to create a report with the overdue books, the date due and the call number. I don't see the CALL number as a field I can use in the report. I do see DEWY, but I have put all my CALL numbers in the CALL field. Is there a way I can copy all of my CALL numbers into the DEWY field automatically so I can show that when I run the report?



Copyright © 2024 · All Rights Reserved · PrimaSoft PC