date plus 365

[NETHROW]

my db is for equipment certification.
I'm trying to figure out how to do the following:
I have a date field when employees are certified on equipment.
I want to create a variable date field for when their certification expires. 1 year (365 days) after the initial certification date. ie
Cert date 01/01/2005
Cert exp date 01/01/2006
I'm using the short date format.
I want this to be calculated in the table and not through a querie or report.
Can someone help?

 

[PHV]

In the data entry form you may create an AfterUpdate event procedure for the [Cert date] control:
Me![Cert exp date] = DateAdd("yyyy", 1, Me![Cert date])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886