Hey guys im really new in Microsoft Access my school give a assignment on Library management system in access only. and now im stuck .
1.Condition is
Fine - .10p fine per book after 10 days.
i could not set this condition on my database.i tried a lot but still cant understand how to do it. i dont have that much time to read all the things .so please help me. thanks
Fine Table i have attributes
(PK)Fine Id - Auto Number.
Student id - Text.
Fine ---- Currency .
Book Isbn ----- Number.
Weekly Fine ----- Currency.
bappys2002
0
Newbie Poster
timothybard
12
Posting Whiz
I'm not sure I understand what the problem is. For a library system that includes fining its patrons, I would create a database that tracks when the patron checks out an item and when the item is checked back in. After the item is checked in, it would see if the item was late and, if so, then add a fine to the "fine" table. That would require either an append query or vba.
Another approach would be to just record the check out date and check in date and always calculate the fine that is due instead of explicitly recording the fine that is due. To do that, you would simply create a query to calculate the difference in days between the check in date and check out date and calculate the fine based on those two days.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.