Results 1 to 6 of 6
  1. #1
    z1efuller1 is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2009
    Posts
    9

    Probably missing something easy

    Hello everybody,



    New to the forums and relatively new to Access.

    I am using 2007 and I am trying to get a future date to populate in a table using another column in the same table [Emp_Start_Date]. I am entering this exp in the Default Value in the future date column field properties:

    =DateAdd("d",150,[Emp_Start_Date])

    Every time I try to save after entering this expression I get a error saying

    "The database engine does not does not recognize either the field 'Emp_Start_Date' in a validation expression, or the default value in the table 'Start_Dates'."

    I know the expression is correct because I got it to work with a Date().

    What am I doing wrong?

    Any help would be greatly appreciated, and thank you in advance.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Primarily, you should not waste disk space on a field that is calculated from another field in the same record. The value can easily be created in a query if you need it.

  3. #3
    z1efuller1 is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2009
    Posts
    9
    So I should just add it to the Update query to automatically populate the field when the update occurs?

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    The field should *never* exist. When you need the value just create it in a select query of the table.

  5. #5
    z1efuller1 is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2009
    Posts
    9
    Ohhh, ok, that makes sense. Thanks for your help. I will add it to the query for the reporting end and on the form view.

    Thanks for your help!

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Now you've got it. That is exactly how you should do it.

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

Similar Threads

  1. Easy newbie question
    By pontuse in forum Access
    Replies: 4
    Last Post: 11-08-2009, 08:02 AM
  2. HELP NOOB! Easy question
    By SigmaBlu in forum Queries
    Replies: 1
    Last Post: 10-10-2009, 11:23 AM
  3. Easy Custom Calculation?
    By rjk1080 in forum Queries
    Replies: 6
    Last Post: 07-12-2009, 11:42 AM
  4. Easy question...so why can't I figure it out?
    By bdrago527 in forum Access
    Replies: 1
    Last Post: 10-02-2008, 02:40 PM
  5. easy checkbox question
    By nelsok in forum Forms
    Replies: 1
    Last Post: 06-09-2006, 05:46 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
  •  
Other Forums: Microsoft Office Forums