Calculate current age of person.

  • Thread starter Thread starter Jeff Davis
  • Start date Start date
J

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.
 
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.
 
Back
Top