Dependent date field

[Guest]

Hi, I am trying to build an Access database that has a table with skill
assessments in it. I have a skill, a skill level, an assessment date and a
reassessment date. I want to make the reassessment date automatically appear
as 6 months or 1 year after the assessment date. Does anyone have any ideas
about how I can do this?
Thanks,
Mark

 

[Penguin]

What you need is code that checks the reassessment date and a date + 1
year. In the OnCurrent of the form insert this code:

If Me!txtDate = DateAdd( "yyyy", 1, Me!txtDate) Then
Me!txtDate.Visible = True
Else
Me!txtDate.Visible = False
End If

Replace the txtDate with your control name.

 

[Ronald W. Roberts]

Hi, I am trying to build an Access database that has a table with skill
assessments in it. I have a skill, a skill level, an assessment date and a
reassessment date. I want to make the reassessment date automatically appear
as 6 months or 1 year after the assessment date. Does anyone have any ideas
about how I can do this?
Thanks,
Mark

Look at DateAdd.

Ron

 

[G. Vaught]

ReassessmentDate:[AssessmentDate]+60 placed in a query to give you the new
Assessment Date. You can also create a textbox field where this calculation
can be created. The difference is that you don't have to specify a qualifer
field name prior. Just type in the textbox Control Source area under
Properties: =[AssessmentDate] + 60.