Calculated field

S

Sarah M

How would I be able to calculate the current age of a person based on a
birthdate field (Short Date 99/99/0000;0;_) Basically, I want a report that
has name and age.

Many thanks for any assistance.
 
J

Jim/Chris

Put this in the control source of an unbound control:
=DateDiff("yyyy",[DOB],Date())-IIf(Format([DOB],"mmdd")>Format(Date(),
"mmdd"),1,0)

Jim
 
Top