Calculate Years

[Alan Mews]

Hi All
Being a Newbie and tried very hard to get my Database (Access) to calculate
the age of a person, in years, from the Date of Birth.

The Fields are:
DateofBirth minus Today's Date =Age, in years, of person.

Any help will be much appreciated.
Did post before but I think it got lost, sorry.
Many thanks
P...

[Ruskin Hardie]

You could try;

DateDiff("yyyy", Date_Of_Birth, Now)

BUT; there is a catch.... If you have the Date_Of_Birth as 01-Jan-2000 and
31-Dec-2000, they will both give you 3 years.... So you may have to a
comparison of the date and month as well, to figure out if you need to
subtract a year....

"Alan Mews" <al*******@btinternet.com> wrote in message
news:bn**********@titan.btinternet.com...

Hi All
Being a Newbie and tried very hard to get my Database (Access) to calculate the age of a person, in years, from the Date of Birth.

The Fields are:
DateofBirth minus Today's Date =Age, in years, of person.

Any help will be much appreciated.
Did post before but I think it got lost, sorry.
Many thanks
P...

[Bruce M. Thompson]

> Being a Newbie and tried very hard to get my Database (Access) to calculate

the age of a person, in years, from the Date of Birth.

The Fields are:
DateofBirth minus Today's Date =Age, in years, of person.

See:

Age() Function
http://members.iinet.net.au/~allenbrowne/func-08.html

--
Bruce M. Thompson, Microsoft Access MVP
bt******@mvps.org (See the Access FAQ at http://www.mvps.org/access)

NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<

[Alan Mews]

Many Thanks for all your help.

A....
"Alan Mews" <al*******@btinternet.com> wrote in message
news:bn**********@titan.btinternet.com...

Hi All
Being a Newbie and tried very hard to get my Database (Access) to calculate the age of a person, in years, from the Date of Birth.

The Fields are:
DateofBirth minus Today's Date =Age, in years, of person.

Any help will be much appreciated.
Did post before but I think it got lost, sorry.
Many thanks
P...