date fields

  • Thread starter Thread starter uziel hill
  • Start date Start date
U

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'
 
And just where are you trying to put this expression? It's very easy to do
in a query: [OrderDate] + 365
 
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.
 
Back
Top