inventory control of books

[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.

 

[John W. Vinson]

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.

I take it that these are separate *tables*, not separate *databases*?

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.

If you're storing the date returned in Book Status, you can just create a
query using a criterion of

IS NULL

on this field to find all the books that have been checked out but not checked
in.

John W. Vinson [MVP]