J
jlydon
I use Access and have a table with books entered for our library. I
have another database with the ID number of each student. I have a
third database which is called Book Status. When a student takes out
a book, I scan the barcode of the book in and the barcode from the
student ID. (These are tied respectively with a relationship to the
Book database and the student database). When the student returns the
book in the Book Status database I scan the barcode of the book and
that of the student and enter the return date.
I want to be able to print a report that will tell me only which books
have not been returned. At present I can only print a report that
tells me when books were taken out, and when books were returned, but
I can't have it print one that only indicates which books have not
been returned. Any help would be appreciated. Thanks.
have another database with the ID number of each student. I have a
third database which is called Book Status. When a student takes out
a book, I scan the barcode of the book in and the barcode from the
student ID. (These are tied respectively with a relationship to the
Book database and the student database). When the student returns the
book in the Book Status database I scan the barcode of the book and
that of the student and enter the return date.
I want to be able to print a report that will tell me only which books
have not been returned. At present I can only print a report that
tells me when books were taken out, and when books were returned, but
I can't have it print one that only indicates which books have not
been returned. Any help would be appreciated. Thanks.