hi all,
firstly like to say thanks for your post on previous
members as the forum has helped alot, but i cant seem to find this
solution and search for hours on end...
basically iam building a small library system and i am at the
part where i need to calculate wether the book is overdue and issue a
fine
atm i have a filter search which finds the Loan through the
book copy number and ISBN number this displays the userid and the start
date of which the loan was issued in a gridview,
i then added a
colum to the loan table to allow the "librarian" to insert the return
date of the book with the update feature on the gridview, and then once
then update is made make a calucation with those 2 dates
and
either issue a output of "thanks for returning the book" or "you book is
overdue by ... and your charge is ..." depending on the results. the
oveduerate is if its overdue by 14days then add £0.20 fo ...
Go to the complete details ...