Results 1 to 3 of 3
  1. 04-11-2009, 03:59 AM #1
    hedleyw
    hedleyw is offline Novice
    Join Date
    Apr 2009
    Posts
    2

    Calulating derived date in table

    Dear all

    Trying to get a field in a table to show a date derived from another field in the plus 5 years. What is the best way to do this please? Where ADR Valid From is the start date =[ADR Valid from]+1825 to calculate the end date will work in a form but not in a table.
    Reply With Quote Reply With Quote
  2. 04-11-2009, 09:35 AM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Don't waste table space with a calculated field for a number of reasons. Just use DateAdd() in a query to calculate the value you need.
    Reply With Quote Reply With Quote
  3. 04-12-2009, 02:33 AM #3
    hedleyw
    hedleyw is offline Novice
    Join Date
    Apr 2009
    Posts
    2
    Thank you for the suggestion

    Hedley
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. one date entered to hit 3 fields in one table how?
    By techexpressinc in forum Queries
    Replies: 0
    Last Post: 12-10-2008, 10:43 AM
  2. Top Date per Date in another table
    By danneedham in forum Queries
    Replies: 1
    Last Post: 05-28-2008, 05:47 PM
  3. Access Date/Time....I need a "generic" date.
    By beastmaster in forum Access
    Replies: 2
    Last Post: 12-29-2005, 12:55 PM
  4. Make sure end date is one year greater than start date
    By AimeeK in forum Forms
    Replies: 1
    Last Post: 12-09-2005, 10:29 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums