Calculated field with age

[john]

I've searched google but can't find what I need.
In my form I have a field Date Of Birth. Netxt to that field I would like to
put a calculated field that shows the age of that particular person,
calculated from today.
What's the easiest way of doing this?
Thanks in advance,
john

[Arno R]

"john" <jo**@test.comschreef in bericht news:T8********************@casema.nl...

I've searched google but can't find what I need.

?????
How did you search ?? This question has been asked and answered lots of times...

http://groups.google.com/group/comp....ulation&qt_g=1

Arno R

[Bob Quintal]

"john" <jo**@test.comwrote in
news:T8********************@casema.nl:

I've searched google but can't find what I need.
In my form I have a field Date Of Birth. Netxt to that field I
would like to put a calculated field that shows the age of
that particular person, calculated from today.
What's the easiest way of doing this?
Thanks in advance,
john

age = datediff("yyyy",dob,date())
for a more accurate age, use the reknowned Allen Browne's age()
function which handles a subtle error in the expression I wrote
above. It also lets you specify a date different from today if you
need to.
http://allenbrowne.com/func-08.html
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[john]

I found so many pages on 'access age calculated field', but not the one I
was looking for.
john

"Arno R" <ar***********@tiscali.nlschreef in bericht
news:44**********************@text.nova.planet.nl. ..

"john" <jo**@test.comschreef in bericht
news:T8********************@casema.nl...

I've searched google but can't find what I need.

?????
How did you search ?? This question has been asked and answered lots of
times...

http://groups.google.com/group/comp....ulation&qt_g=1

Arno R

[john]

"Bob Quintal" <rq******@sPAmpatico.caschreef in bericht
news:Xn**********************@66.150.105.47...

"john" <jo**@test.comwrote in
news:T8********************@casema.nl:

>I've searched google but can't find what I need.
In my form I have a field Date Of Birth. Netxt to that field I
would like to put a calculated field that shows the age of
that particular person, calculated from today.
What's the easiest way of doing this?
Thanks in advance,
john

age = datediff("yyyy",dob,date())
for a more accurate age, use the reknowned Allen Browne's age()
function which handles a subtle error in the expression I wrote
above. It also lets you specify a date different from today if you
need to.
http://allenbrowne.com/func-08.html
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Thanks!
john