calculate age

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm new to this: need to calculate age from date of birth. Tried the Help
suggestion but get #NAME error when I apply it. Any suggestions? My 2 field
names are" Date of Birth" and "Patient Age".
thanks!
 
I'm new to this: need to calculate age from date of birth. Tried the Help
suggestion but get #NAME error when I apply it. Any suggestions? My 2 field
names are" Date of Birth" and "Patient Age".
thanks!
Click to expand...

Patient Age should NOT be stored in your Table, *at all*. If you store
it today, it will be wrong in less than a year.

Instead, it should be *calculated* as needed in a Query, or in the
Control Source of a textbox on a form or report, using an expression
like

Patient Age: DateDiff("yyyy", [Date Of Birth], Date()) -
IIF(DatePart("y", [Date Of Birth]) > DatePart("y", Date()), 1, 0)

John W. Vinson[MVP]
 
Back
Top