Adding a year to a date entered and getting a reminder when date is almost reached

[emanuel.levy]

I have to keep track of renewals of a certification. I have a table
with the following fields

Employer
Certification_Start_Date
Certification_Request_Number


All certifications last for One Year so I need to display in the Form
that is used to enter the data the Expiration Date which would be (
Certification_start_date + 365 ) And I don't know if that can be done
or how to do it.

I also need to have a report? give a reminder when there is 95 then 65
days from the end of the certification.

All help would be appreciated.

 

[mscertified]

Check Access HELP for the DATEADD function.
You will probaly have to cater for a certification starting on Feb 29th.

Dorian

 

[Klatuu]

ExpireDate = DateAdd("yyyy", 1, Certification_Start_Date)
FirstWarnDate = DateAdd("d", -95, ExpireDate)
SecondWarnDate = DateAdd("d", -65, ExpireDate)

 

[John Vinson]

I have to keep track of renewals of a certification. I have a table
with the following fields

Employer
Certification_Start_Date
Certification_Request_Number


All certifications last for One Year so I need to display in the Form
that is used to enter the data the Expiration Date which would be (
Certification_start_date + 365 ) And I don't know if that can be done
or how to do it.

Put a textbox on the form with a Control Source

=DateAdd("yyyy", 1, [Certification_Start_Date])

I also need to have a report? give a reminder when there is 95 then 65
days from the end of the certification.

Create a qeury with a criterion on [Certification_Start_Date] such as

< DateAdd("d", -270, Date())

for the 95 days, -300 for the 65 days. It'll be a day out in leap
years but close enough. Your Startup form can check to see if this
query returns any records and pop up a form displaying them if so.

John W. Vinson[MVP]