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

M

mac010904

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.
 
A

Allen Browne

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])
 
Top