Isse Date & Expiry dates

S

Shameem Dubai

Iam using Access2003,
It is regading Autodate Update, i have " Issue Date" feild , "No. days"
field and "Expiry Date" field.
The "Expiry date" field has to be upadated by adding Issue Date+No.of Days.
Means, IssuDate =10/10/2007, No.of Days:365
Expiry Date should be updated automatically to 10/10/2008
Please Help
 
D

Douglas J. Steele

There's no such thing as Autodate Updates in Access.

You should not be storing both No. days and Expiry Date. Only one of the two
fields is necessary, since the other field can be derived.

My recommendation would be just to store No. days, then create a query where
you calculate Expiry Date. Use the query wherever you would otherwise have
used the table.
 
Top