addate function

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top