Change DOB to age

[denl10]

Hello,

I have two fields "birthdate" and "datetested" in my database. I would like to create another field called "age" that is automatically filled in from the value in the 'birthdate' field, but relative to the "datetested" field. In other words I want to know the age of the person when he/she was evaluated. I'm not sure where to begin in terms of the code. Any help is appreciated.

Thanks,

Dennis

[RuralGuy]

That calculation can *always* be done in a query at any time. There is no reason to use a field for this information.

[Rainlover]

Try this

If Month(DateToday) < Month(Bdate) Or (Month(DateToday) = _
Month(Bdate) And Day(DateToday) < Day(Bdate)) Then
Age = Year(DateToday) - Year(Bdate) - 1
Else
Age = Year(DateToday) - Year(Bdate)
End If
End Function

If it does not work for you then google "access age"

And yes RG is correct this should be done at runtime and not stored.