LIMITED BORROWING BOOKS in MS ACCESS

[myady02]

hi guys! i have a little problem about how can i limit the borrowing books for 2 books per student
for example
the student can borrow 2 books only in the library


i want to know the code of this.
sorry for my english

 

[namliam]

Select count(*) 
from YourBookBorrowingTable 
where returndate is null
and  studentID = TheStudentYouarelookingfor

Something along those lines?

 

[myady02]

sir if the student is is already have two borrowed book
then he/she will try to borrow again
i want to automatically pop-up msg and say "Valid for 2 books only"
what is the ecxact code for that?

this is my fields
borrowers ID
borrowers Name
book code
title
author


i want to valid for 2 books per student only

sorry for my english again