Results 1 to 3 of 3

Thread: Calculations

  1. #1
    Join Date
    Jan 2004
    Posts
    106

    Unanswered: Calculations

    i have created a library database and i need to come up with a way of producing a list of books that are overdue for return and display the current fine due. i have come up with a fine calculation which is displayed below:

    IIf([Days Late]<7,0,IIf([Days Late]<14,0.3,IIf([Days Late]<21,0.6,IIf([Days Late]<28,1,IIf([Days Late]<56,1.5,IIf([Days Late]>56,3))))))

    PLEASE HELP!

  2. #2
    Join Date
    Dec 2003
    Location
    Toronto, Ont. Canada
    Posts
    238

    Re: Calculations

    Originally posted by craig_dixon
    i have created a library database and i need to come up with a way of producing a list of books that are overdue for return and display the current fine due. i have come up with a fine calculation which is displayed below:

    IIf([Days Late]<7,0,IIf([Days Late]<14,0.3,IIf([Days Late]<21,0.6,IIf([Days Late]<28,1,IIf([Days Late]<56,1.5,IIf([Days Late]>56,3))))))

    PLEASE HELP!
    I don't understand the question Craig...
    Are you getting syntax errors with that statement?

  3. #3
    Join Date
    Jan 2004
    Posts
    106
    there is nothing wrong with the statement, i just dont know how to produce the list and calculate the CURRENT fine due

Posting Permissions

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