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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top