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
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
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?
Handy Library Manager 4.4, review new features
Labels Printing Software for Windows
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 © 2024 · All Rights Reserved · PrimaSoft PC