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.