Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2013
    Posts
    3

    Unanswered: MS Access Query Coding help

    Tables

    Return table:
    - Return No (PK)
    - Returned Date

    Lending Table:
    - Lending No (PK)
    - To be returned date
    - Fee (If Overdue. Per day)

    I would like a code in ms access to calculate the number of days it has been since the overdue date. In addition, the code to calculate the total Fee.

    Any help would be much appreciated.
    Thank you.

  2. #2
    Join Date
    Jan 2005
    Posts
    146
    You can use the DateDiff() function to calculate the number of days between two dates:
    Code:
    DateDiff("d",#05/05/2013#,Date())
    You can place this code in a query or VBA or even as the control source for a form or report control.

  3. #3
    Join Date
    Jul 2013
    Posts
    3
    Thanks for the Code. I've been able to modify your code to my liking.

    Thanks again.


  4. #4
    Join Date
    Jan 2005
    Posts
    146
    Your welcome.

Tags for this Thread

Posting Permissions

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