Computing Ages Using Access 2000

[Mark Watlock]

age: (Now()-[birth date])/365
Entering this expression in to a query returns the corrent
answer with 2 decimal places. By changing the decimal
places to 0 and format fixed rounds the number of years
up. How can we return an "unrounded" number to display
the persons correct age.

Thank you in advance.

 

[Dale Fye]

See Doug Steele's
(http://members.rogers.com/douglas.j.steele/Diff2Dates.html) site for
a good function.

Another, shorter one that gives age only is available on Allen Brown's
site (http://allenbrowne.com/func-08.html)

--
HTH

Dale Fye


age: (Now()-[birth date])/365
Entering this expression in to a query returns the corrent
answer with 2 decimal places. By changing the decimal
places to 0 and format fixed rounds the number of years
up. How can we return an "unrounded" number to display
the persons correct age.

Thank you in advance.

 

[Van T. Dinh]

Plse give an example of "unrounded" number considering that you already got
the "correct" (not quite, actually) answer with 2 decimal places.