Calculate age for year of birth

[circles]

I am trying to develop a table that when a person enters the year they were born thier age will be automatically be put into the age field. Any help would be great.

 

[THoey]

Did you look up the DateDiff function in help? Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[dbgirod]

This has worked for me in the past.

Age: DateDiff(&quot;yyyy&quot;,[DOB],Now())+Int(Format(Now(),&quot;mmdd&quot<Format([DOB],&quot;mmdd&quot)