Results 1 to 2 of 2

Thread: Query Problems!

  1. #1
    Join Date
    Jan 2004
    Posts
    106

    Unanswered: Query Problems!

    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.

    PLEASE HELP

    I have attatched a screen shot of the deign views of the two queries.

  2. #2
    Join Date
    Jan 2004
    Posts
    106
    attatchment
    Attached Thumbnails Attached Thumbnails 1.jpg  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •