Results 1 to 1 of 1

Thread: Calculations

  1. #1
    Join Date
    Jan 2004

    Unanswered: Calculations

    i have writen two queries that ask the user for a book number and then calculate a fine based upon how many days late the book is for return query one is a select query that works out how many days late the book is and query2 is an update query, based upon query and, that calculates the fine and stores that value i teh fine field of the loan table

    when i run the second query, it updates to fine field in the loan table but leaves it blank

    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