how do i calculate an age using MS Access? I'm a novice.

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

Guest

I don't know how to inter a query yet. I need to calculate age and have the
answer displayed. one column has the birthdate and other the age.
 
See:
http://allenbrowne.com/func-08.html
for an explanation of what works and what does not.

If you copy the Age() function from that page, paste it into a new module,
you can add a text box to your form or report, and set its ControlSource to:
=Age([birthdate])
 
Back
Top