How to add expiry date automatically in MS Access?

[Devadath Sreelayam]

I've created a table to store data from my shop. Basically I'm issuing certificates to my customers. Some certificates will have 6 months validity whereas some have one year validity. How can I automatically add expiry date with respect to the type of certificate and issuing date?

[CJ_London]

you don't need to store the date, only the validity period. Assuming this is stored as 6 or 12 months, you can then calculate the expiry date as

dateadd("m",validityperiod,issuedate)