addate function

[Guest]

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

 

[Graham R Seach]

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