Calcualed value

[Qasim]

I am using ms-access to maintain test data for an application. Each record in msaccess is used as a test record. There are many date fields which need to have value depending on the current date (e.g. installment end date = Today() + 1 year + 1 day). This rule is different for each record. The testing is carried out by test automation scripts. Tester does not want to have this rules in the automation scripts to make the scipts unique for all test data. Is there any way I can store a calucalted date depending on the current date in the MS-Access table (like Now() + 1year + 2 Months - 15 days)



Thanks,

Q

[NTC]

yes you can store a calculated date depending on the current date.

easiest method is in the data entry form; in the AfterUpdate event of the the current date field - put your calculation - and it will auto update your future date field...

you mention that every record will have a different algorithm; and that would make it alot more challenging depending on who is the person deciding & entering that algorithm....