Solved Expiry date for many certificates (1 Viewer)

Sam Summers

Registered User.
Local time
Today, 01:28
Joined
Sep 17, 2001
Messages
939
How the forum member solved it was he added a field in the EmployeeCert Table called PeriodinYears where each certificates validity is added and in the query he added this:

EmployeeCert.PeriodinYears, DateAdd("yyyy",[PeriodInYears],[EffectiveDate]) AS [Expiry Date]

So on the form the text box ExpiryDate now works in relation to each persons date when they attained the certificate and the period of validity for each different certificate.
 

Users who are viewing this thread

Top Bottom