Calculated field

[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.

 

[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