I have created two queries, one to find the days late of a book and the other to work out the fine of the book. i need the queries to ask the user which book number they want to work out the fine for and then calculate the fine and store that value in the "fine" field of the "loan" table. i only want it to update the one record tho.
basically, on the returns form, the user enters the "date Returned" and "book number" then presses a button that calculates the fine and stores it in the "fine" field of the "loan" table.
I have attatched a screen shot of the deign views of the two queries.