date fields

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'
 
L

Lynn Trapp

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

validation rule invalid? 1
How do I calculate this? 1
None working SQL - help please. 2
Year to Date subquery 3
Extracting Month and year 1
DLookup and Nz 0
Age in Days If Then 5
Trying to add Long Integer field 1

Top