Calculate Age From Birthdate

Guest · May 21, 2004

Hello

I have a birthdate listed in a column and I want to calculate the age of the person.

Any help will be appreciated

Sandy

Joan Wild · May 21, 2004

Guest · May 22, 2004

Thank you SO MUCH

This works beautifully!

Sand

----- Joan Wild wrote: ----

From Allen Browne's sit
http://members.iinet.net.au/~allenbrowne/func-08.htm

Con Giacomini · May 22, 2004

Try entering this expression in your query:

=IIf(IsNull([DOB]),"
",Year(Now())-Year([DOB])+(DateSerial(Year(Now()),Month([DOB]),Day([DOB]))>N
ow()))