addate function

I am trying to set up a dtabase of Students who must be retrained in 3 years.
At present we are having to type in the retraining date when in table mode

I can't work out how to get the date retrain field to take the date in the
Training date field and add 3 years automatically although I can do it in a
form but this does not show up in the table

Many thanks in anticipation

Check the online Help for the DateAdd() function.

Your problem is going to be that there's no way to execute anything from a
table. The only way you can calculate the retrain date is to use a form, or
by some other means, execute a query or some code.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Davests" wrote in message
...
I am trying to set up a dtabase of Students who must be retrained in 3
years.
At present we are having to type in the retraining date when in table mode

I can't work out how to get the date retrain field to take the date in
the
Training date field and add 3 years automatically although I can do it in
a
form but this does not show up in the table

Many thanks in anticipation