In Access, what is the formula for caculating a person's age using a date-of-birth field?

=Int(DateDiff("d",[DOBField],Now())/365.25)

David R

In one database I used this in a calculated field:

AGE: DateDiff("yyyy",([DOB]), NOW())

This should calculate their current age (in total years) as of the time you run the query.

Is this what you needed?

Bluez