Calculate current age of person.

[Jeff Davis]

Hi all. Any suggestions on how to calculate and show a
persons current age on a form or report.
I have a birthday field for them and can't seem to figure
out a way to reflect their current age at any given moment
on my report.
Thanks for your input in advance.

 

[Ken Snell]

Take a look at this web site link:
http://www.mvps.org/access/datetime/date0001.htm

 

[Richard]

Open the form or report in design view(based on the table
or query with the "birthdate"). in the control of
the "item" where your wanting to show the age, on the data
tab-control source field, type in the formula: DateDiff
("yyyy",[tablename].[Birthdate],Date())-1
The -1 at the end is because the formula will start with 1
instead of zero to do the count.