Results 1 to 4 of 4
  1. #1
    Desstro's Avatar
    Desstro is offline Competent Performer
    Windows XP Access 2010 (version 14.0)
    Join Date
    May 2010
    Posts
    185

    Question DateAdd Function

    In a Table I have OriginalTestDate--- Expires(days)--- RetestDue

    Using the expression builder in the default value under the general tab for RetestDate, how do I get it to return a value of OriginalTestDate + Expires(days)? I know I can do this in a query but I would like to know how to do it in the table properties.



    Please help.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    So the admonition against storing calculated values does not apply here?

  3. #3
    Desstro's Avatar
    Desstro is offline Competent Performer
    Windows XP Access 2010 (version 14.0)
    Join Date
    May 2010
    Posts
    185
    Oh no. I took your advice. I am just curious and a bit frustrated that I haven't been able to figure it out is all.

    It will bug me until my days end knowing that it is possible and more than likely easy and I cant figure it out.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You cannot reference another field in a table in the Default property of a field.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Problem with DateAdd
    By Lo-Wang in forum Queries
    Replies: 6
    Last Post: 02-13-2019, 10:55 AM
  2. DateAdd error in MS Office 2010
    By Noah4x4 in forum Access
    Replies: 7
    Last Post: 03-15-2011, 05:08 PM
  3. dateadd help
    By dubsdj in forum Queries
    Replies: 3
    Last Post: 03-03-2011, 07:22 PM
  4. Help Please - DateAdd Function
    By graviz in forum Queries
    Replies: 3
    Last Post: 03-02-2010, 02:34 PM
  5. Change Between by DateDiff or DateAdd.
    By wagner.bts in forum Queries
    Replies: 1
    Last Post: 06-05-2009, 11:24 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums