Renew field for library database

[Marko]

HI there, I currently have a database which records book
Loans.

I am creating a Loan query which currently has the
fields:

Student Name
Book Number
Loan Date
Loan Due
Loan Returned
Days Late
Fine Amount

What expression/Validation could I use to prevent a book
from being
renewed more than twice by the same student.

I do not have a renewed field I would like to add it to
my Loan query with the others I just need an expression
to do so.

if this helps my table relationships are:

STUDENT LOAN INSTANCE BOOK

Student Name Student Name Book Number ISBN
Age Book Number ISBN Author
Class Loan Date Instance Number Genre
Loan Due Department
Loan Returned Age Group
Fine Publisher
Book Title



Thanks

 

[Guest]

You might try making a totals query based on Loan Table.
Group by student name, group by book number, and count by
book number. This will tell you how many times each
student has borrowed a book. If you include this query in
your loan query, you should be able to see how many times
the student has borrowed the book already.

Hope this helps.