Results 1 to 4 of 4

Thread: Insert Date

  1. #1
    Join Date
    Jul 2008
    Posts
    5

    Unanswered: Insert Date

    Hi All

    I am trying to generate a automatic input of a date from previously entered date in an Access table. I have a field 'DATE FINALISED' which when entered I would like to enter a date 14 days latter into the field 'FOLLOW UP DATE'.

    Any assistance would be greatly appreciated.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Take a look at the DateAdd function.
    Paul

  3. #3
    Join Date
    Jul 2008
    Posts
    5
    Hi pbaldy

    Being a very basic user of Access could you please explain

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    the date add functin does what you want
    mind you why woudl yu wnat to stoe it .. its a derived value..
    either use dateadd in a query
    or int he forms on current event + on before update event
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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