date fields

[uziel hill]

Does anybody know how to get access 2007/2010beta to add a year on to a date
in a field?
I want it to automatically add 365 to the 'OrderDate' field whilst still in
the table - it works fine in a query
It comes up with the error message 'Access does not recognise the field
'OrderDate' in a validation expression'

 

[Lynn Trapp]

And just where are you trying to put this expression? It's very easy to do
in a query: [OrderDate] + 365

 

[Jerry Whittle]

You can't do this in a table. You can do it in a query, form, or report.

Even there you have to consider Leap Years. You might want to look into the
DateAdd function.