J
jlydon
I use Access and have a database called Book Status which has a
relationship link to another database table which contains the
contents of the library (books database). Each book has a unique code
number. At the same time I have a database with the information of
each student, where an individual student ID number is found. The
Book Status database allows me to scan the student ID number and scan
the book bar code, so that I can then know which student has which
book when they take out a book. 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.
This seems to be because each time I scan into the Book Status data
base it creates a different row of data, so when a student takes out a
book the date of exit is entered, when the student returns the book,
the date of return is entered on a completely different line in the
table. So any report shows that the original book is still out since
the return date is not entered on the same line as the exit date.
Is there a way to resolve this so I can print out a report of books
that are still out. At present the report shows all books out since
the return column is empty even whey the book is returned. Any help
would be appreciated. Thanks.
relationship link to another database table which contains the
contents of the library (books database). Each book has a unique code
number. At the same time I have a database with the information of
each student, where an individual student ID number is found. The
Book Status database allows me to scan the student ID number and scan
the book bar code, so that I can then know which student has which
book when they take out a book. 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.
This seems to be because each time I scan into the Book Status data
base it creates a different row of data, so when a student takes out a
book the date of exit is entered, when the student returns the book,
the date of return is entered on a completely different line in the
table. So any report shows that the original book is still out since
the return date is not entered on the same line as the exit date.
Is there a way to resolve this so I can print out a report of books
that are still out. At present the report shows all books out since
the return column is empty even whey the book is returned. Any help
would be appreciated. Thanks.