Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    11

    Unanswered: Access Calculations

    I am building a form where i have a date completed field for a course, and i have an expiry date field that has to have a date 3 years from the completed date. I plan to use this for a query to find when permits expire. I cant figure out the formula for this i have tried many and cannot get it to work. Any help would be apreciated

  2. #2
    Join Date
    Sep 2003
    Location
    MN US
    Posts
    313
    This worked for me:

    = DateAdd("yyyy", 3, [Date_Completed])

    HTH,

    Chris

Posting Permissions

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